SQL + dates

[furious5]

I have a table in MySQL - ID, Start_Date, End_Date

I want to be able to take a string and show the availability for that particular month based on the entries within the table.

Any ideas of the best way to do an SQL search to acheive this?

[LordShryku]

Probably using the MONTH function in MySQL

http://www.mysql.com/doc/en/Date_and_time_functions.html