SELECT COUNT(col_name) FROM mytable WHERE <some condition> This will return the number of items with that condition in that columne, name col_name
-----Original Message----- From: Ron Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 11:19 AM To: [EMAIL PROTECTED] Subject: [PHP] Newbie Question about PHP / MySQL -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello All: How do I read all of the data from just one column, then develop a count based on those items? I think I start with mysql_fetch_field(), but right there I get stuck. Any ideas to point me in the right direction? Thanks in advance, Ron C. -----BEGIN PGP SIGNATURE----- Version: PGP 7.1 iQA/AwUBPGQIlESpEYIqgLQzEQIzeQCg/JWV1gTtsr0msG3FyUsLK3oaHL8AoNls m6KXlfmfZPhEIJOdvTX4VBRw =71Ww -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php