Select count() where

[merylvingien]

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?