counting rows in database

[jenniferG]

This is  probably silly, but  in the below script, does $FIND  contain the count

or do I have to do something in addition? The manual  covers just mysql command line

querys.

 

/*

$NOUNITQUERY="SELECT COUNT(*) FROM SISTOCK WHERE CAMERAMODEL='$CAMERAMODEL'";

$FIND= mysql_query($NOUNITQUERY);

*/

 

Thanks,

 

Jennifer

[teng84]

$NOUNITQUERY="SELECT COUNT(*) as my_count FROM SISTOCK WHERE CAMERAMODEL='$CAMERAMODEL'";

$FIND= mysql_query($NOUNITQUERY);

$got_it = mysql_fetch_assoc($FIND);

$value_is_here = $got_it[my_count];

 

note: better to use spsecific field rather than *

[Toshiba23]

if you want to know how many rows are returned from your query, use mysql_num_rows($resource)