merylvingien Posted October 3, 2010 Share Posted October 3, 2010 Hi fellas, having a bit of trouble getting a count from the database where the field is not empty? $count= "SELECT COUNT(unid) FROM table"; $result2 = mysql_query($count) or die("Select Failed!"); $counter = mysql_fetch_array($result2); echo $counter[0]; From what i have read, this should get all the not null results from the field, but it gets all of them. Some are empty, the ones i want have various id numbers in them. Is there a way to get just the numbers where there is an id number present? Link to comment https://forums.phpfreaks.com/topic/215041-select-count-where/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.