[snip] If you want blue eyes only you would handle that in the query; SELECT COUNT(eyeColor) FROM theTable WHERE sex = 'male' AND eyeColor = 'blue'
And if your are returning one row ... $result = mysql_fetch_object($db); // no while loop echo "We have " . $result->colorCount . "guys with " . $result->eyeColor . "eyes!<br>\n"; [/snip] Dang early morning typos -- SELECT COUNT(eyeColor) AS colorCount FROM theTable WHERE sex = 'male' AND eyeColor = 'blue' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php