mysql : find anything that is today or older... help

Associate
Joined
24 Jul 2004
Posts
1,580
Location
Preston, Lancs
Is it possible to run a query using php and mysql that selects anything less than or equal to todays date?

so far I have this:

PHP:
$query="SELECT * 
		FROM lsql_Links 
		WHERE (Status=200 OR Status=201) 
		AND isValidated='No' 
		AND Links.isActive='Yes' 
		AND Add_Date <= NOW()";

But that just displays anything from today / NOW. It seems to be disregarding the <= bit.

Any help... im sure this is pretty simple.
 
edit - ignore, its late and I am silly - it wasn't <= NOW that was the problem, it was that I have no status 200 or 201 links.

Ignore or delete, sorry!
 
Back
Top Bottom