If I understood you correct, you want to know the amount of the rows in your table.
Here you go (Assuming ID is the field you use to ident your rows): "...count(ID) AS CountValue..." then treat CountValue as any field in a table. Niklas -----Original Message----- From: Mason Batley [mailto:[EMAIL PROTECTED]] Sent: 31. tammikuuta 2002 8:31 To: [EMAIL PROTECTED] Subject: [PHP] mysql bleh, its not working I'll take another approach, If I use a count(*) query, it will return 1 record with a value, possibly 0. what command can I use to grab it from $result ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]