The semi-colon is gone, although I didn't even notice it! I am using two 
different queries, one for count and the other to access the data itself.  
After running mysql_fetch_assoc, is foreach ok for accessing array members, or 
is there a more subtle approach?
So it's working now? If it is, you won't need to do a separate COUNT() query... you could use either a count / sizeof after fetching all the data, or a mysql_num_rows call.

Foreach'll work fine, but in general I access the array's members by their associated column name's. If you don't need the column names as keys you can use mysql_fetch_row instead of mysql_fetch_assoc.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to