Need help with SELECT COUNT please

[mark_baillie]

Im using a DSNless connection to an access database. I know the connection is okay because i can pull all the data out no problem.

So I want to use COUNT in my SQL string, heres what i've got
$SQL = "SELECT COUNT(*) AS var_count FROM table_users";
$rs_users = $db_connection->execute($SQL);

The question is, how do I reference the result ?
Is it
echo($var_count);
echo($var_count->value);
echo($rs_users->$var_count->value);

or how ?

Cheers
Mark

[barand]

You need to fetch the first (only) row from your result set, then get the field var_count.

I'm not sure of the exact syntax with your connection but with odbc it would be

odbc_fetch_row($rs_users);  //get next row
$count = odbc_result($rs_users,"var_count"); // get field value

Some databases let you fetch in to an array thus

list($count) = mysql_fetch_row($rs_users);
//or
$rec = mysql_fetch_array($rs_users);
$count = $rec["var_count"];

Check the manual to find the equivalent functions.

hth