Query records before todays dates

[wemustdesign]

I have a table, each row has a date. I am wanting the query all of the results before or equal to todays date. I have tried the following but doesn't seem to work.

 

$todaysDate= date("Y-m-d");

$Coursesql = "SELECT * FROM courseDates WHERE date <= '$todaysDate'";

 

 

[premiso]

date is a reserved word in MySQL. So in your SELECT statement either encase `date` it in backticks (`) or rename the column (preferred).

 

Also, I do not see you calling mysql_query and if you are calling it, I would suggest the following be added after it:

 

$result = mysql_query($Coursesql) or trigger_error("Course Query Failed: " . mysql_error());

 

As that will give you a better idea of what is going wrong.

[gizmola]

There's no need to involve PHP in the query when you can use mysql directly.  I've written several articles that include examples of how to do this. 

 

http://www.gizmola.com/blog/blog/archives/51-Exploring-Mysql-CURDATE-and-NOW.-The-same-but-different..html

 

SELECT * FROM courseDates WHERE date 

 

 

[gizmola]

date is a reserved word in MySQL. So in your SELECT statement either encase `date` it in backticks (`) or rename the column (preferred).

 

Also, I do not see you calling mysql_query and if you are calling it, I would suggest the following be added after it:

 

$result = mysql_query($Coursesql) or trigger_error("Course Query Failed: " . mysql_error());

 

As that will give you a better idea of what is going wrong.

 

Actually MySQL is much more permissive than one might think, in terms of the use of keywords for column names.  You don't really need the bactics around the name in this query... it will work ok without them, although your advice is great.