query problem with data
Posted: Fri Oct 10, 2003 3:42 am
I have a problem about a query.
I have a table with 4 column.
1) id (INT)
2) Special_Date (VARCHAR)
3) date_start (DATE)
4) date_finish (DATE)
In a page i use the function date() to have the date of today in a varible like this:
$today = date("Y-m-d");
I need to have a query that select the records from my table where the date of today is included between date_start and date_finish..
anyone can help me?
I have a table with 4 column.
1) id (INT)
2) Special_Date (VARCHAR)
3) date_start (DATE)
4) date_finish (DATE)
In a page i use the function date() to have the date of today in a varible like this:
$today = date("Y-m-d");
I need to have a query that select the records from my table where the date of today is included between date_start and date_finish..
anyone can help me?