Hi Again,

I need help, in many ways but for this time we'll assume it's just for PHP coding. I would like to add a total of non-null fields from one field in my database on a PHP results page. Can someone help me?

The field (Named: Date_In) is a VARCHAR field but I can convert to a date type if need be. I only need to display the total amount of non-null records.

Thanks in advance.

PHP Code:

<php
// Set up your connection first


$sql = "COUNT(*) FROM mytable WHERE Date_In NOT NULL";
$query = mysql_query($sql);

$res = mysql_fetch_assoc($query);
echo $res[0];
?> 


Something about that just feels wrong though, I think I may have brainfarted on something but I'm failing to see it at the moment because I'm in a hurry.

Is it ' WHERE field NOT NULL' or is it 'WHERE field IS NOT NULL' ? Can't remember..., would have to check. Try both and see what happens.

I think you just left out SELECT :

"SELECT COUNT(*) FROM mytable WHERE Date_In NOT NULL";

You could also use AS, like this:

"SELECT COUNT(*) AS Total FROM mytable WHERE Date_In NOT NULL";

Oh yeah..... <scratches head> kinda obvious once somone points it out.... D'OH!

You guy's crack me up. Thanks very much, I'll try them all until one works. Thanks Again. LOL

lol

Hi the coding worked but instead of getting the total I get "Resource id #7" What the heck is this????