Not Consistent (PHP/MySQL Results)

[Anon]

Here's a weird twist, hopefully someone can give me an easy answer...I must be missing something!!!!!

When I type the following in my MySQL Monitor window:

SELECT COUNT(rundate) from log3 where rundate = '2001-09-01';

I get a result of: 1, which is correct.

Now if I use this same code as such in my PHP file...see below.

$datenumber = "SELECT COUNT(rundate)from log3 where rundate = $row[rundate];
$datecount = mysql_query($datenumber);
(*****doesn't matter if I use $row[rundate] or '2001-09-01', still get the same result!)

I get a count of 5 when I know for a FACT only 1 record for this date exists...

Seems to simple...I must be missing something!!!

[Anon]

well....never mind.

I figured it out....

list($datenum) = mysql_fetch_row($datenumber);

solved the problem....