Only give me non-empty count values

[jonki]

I am using the count to display different quantities in my database and I am doing this grafically by setting the width of a gif file to the variable cnt.

My problem is that I have a lot of blanks in my data base and the maximum of these count values is always the empty one which is of no interest and it messes up my results as it is way off the screen. (www.tenercoche.com/z1.php - if you want to see what I mean)

This is what I have been trying to do: Give me the count(*) for the data base but where $make is not empty.

I tried to do this with if statements, while statements in the php and then I thought I could do it in the mysql statement ie "...where !empty(make) ..." but I have had no luck.

Any suggestions how to do this.

Thanks

[dfr574]

you can try..

WHERE make IS NOT NULL OR make <> "";

[jonki]

excellent - thanks a lot.

Jon

[goldbug]

FYI:

If you actually name a column in your count statement:

SELECT COUNT(thecolumn) FROM ....

It will ignore rows that have a NULL value for that column, as opposed to COUNT(*) which will simply count all rows in the table.

Note that it considers "empty" values (for ex: '' <--not null) as a valid column value, and counts it.