Having a problem with a calendar

[badgoat]

Success in linking the day to another page, BUT once on the page, I am having a problem selecting data from a table where the date in the table equals the date I clicked in the calendar. I am sure it has to do with the SQL query, and I am not sure how to associate the date of the calendar to the date recorded in the table. The date_string table column is the type 'date'. What am I doing wrong?

This is the code which links the numbered day to another page:

echo ' <a href="depday.php?year='.$Year.'&month='.$Month.'&day='.$calendar_day.'"> '.$calendar_day,'</a> ';

Here is my current SQL query..

$sqlquery = "SELECT id, diwtitle, date_string FROM diw_alpha WHERE '$calendar_day' = date_string ORDER BY date_string"; 

[thorpe]

dont you want to pull the record by the whole date... not just the day?

[badgoat]

I certainly do, and therein lies my boggle. 😉

I am not sure how to compare the aggrefate of three variables against one variable.

[jkurrle]

I haven't ever bothered storing the date as a date in the MySQL database. I simply store the date as an integer. PHP processes date and time in one second increments since January 1st, 1970. That's good enough for me.

I simply use the date(), time() and strtotime() functions to manage my dates and formatting. I save my results as an integer and that's it.

I admit it's a bit unorthodox, but I'm lazy and this is the easiest solution for me. 🙂