pocobueno1388 Posted June 19, 2007 Share Posted June 19, 2007 Whenever I use SELECT count(*) in a query and there is absolutely nothing in the database, it ALWAYS returns 1. Shouldn't it return 0? <?php $countShows = mysql_query("SELECT count(*) FROM shows WHERE creatorID='$sid'"); echo mysql_num_rows($countShows); //displays "1" ?> Why is this? Link to comment https://forums.phpfreaks.com/topic/56277-solved-query-count-always-returns-1no-rows-in-db/ Share on other sites More sharing options...
akitchin Posted June 19, 2007 Share Posted June 19, 2007 no, because when SELECTing a COUNT() value, it will return the counted number of rows as a value. what mysql_num_rows() is counting as a "row" is actually the number returned; since there's always one COUNT()ed value returned, there will always be one "row" returned. to extract the result from a COUNT(), use mysql_result: $count = mysql_result($countShows, 0, 0); which tells it to grab the value from row 0, field 0. Link to comment https://forums.phpfreaks.com/topic/56277-solved-query-count-always-returns-1no-rows-in-db/#findComment-278008 Share on other sites More sharing options...
pocobueno1388 Posted June 19, 2007 Author Share Posted June 19, 2007 Ah, okay....I understand. Thanks Link to comment https://forums.phpfreaks.com/topic/56277-solved-query-count-always-returns-1no-rows-in-db/#findComment-278021 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.