[SOLVED] SELECT error

[timmah1]

Why is this giving my the error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/home/thegr418/public_html/core/test.php on line 15

 

I see this and I automatically think that the database connection isn't correct, but everything is correct, and there are items in the table

 

Here is the code

$q = "SELECT * FROM blogs ORDER BY rand(".date('d').") LIMIT 5"
or die("There is a problem selecting the blogs ".mysql_error());
$a = mysql_fetch_assoc($q);

 

Thanks in advance

[rhodesa]

you forgot mysql_query()

$q = mysql_query("SELECT * FROM blogs ORDER BY rand(".date('d').") LIMIT 5")
   or die("There is a problem selecting the blogs ".mysql_error());
   $a = mysql_fetch_assoc($q);

[timmah1]

OMG!

(i feel stupid) 

[rhodesa]

OMG!

(i feel stupid) 

 

we all have our days

[timmah1]

Thanks rhodesa