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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
