MySQL count

[Jat421]

Hi,

How can I pass the count from the _Query() to MsgBox()

$i = _Query($sql, "select count(link_no) from temp_tbl")
   With $i
$a = .GetRows
EndWith
MsgBox(0,'Count',$a)

[jdelaney]

count will only return one row, so to .getrows isn't the way. Try .value

or maybe it's .fields(0).Value

i forget, but one should work

Edited June 13, 2012 by jdelaney

[Jat421]

.fields(0).Value worked!!!. Thank you!