Select count but exclude counting empty fields?

[maccas]

Hi, any pointers on how I can exclude counting any instances where a field is empty? i.e I have

$sql = 'SELECT count(reviewid) as num_times FROM reviews WHERE reviewid =' . $id;

I use this to get an average. But some times the average field is empty. So in the above I want to exclude it counting where the average is blank.

[MattAU]

I'm not sure I understand exactly what you mean, but try adding "AND field!= ''" or maybe "AND field IS NOT NULL" to the end of the query.

My first post :)

[coopster]

Sounds like a plan to me. Give it a shot, maccas.

And welcome to WebmasterWorld, MattAU.