Date Specific info?

ghengisape

I am brand new to php and I'm working on a site for a friends band...

I have set up a database and a page that will display all of their recent and future dates as they update them. I am using the yyyy-mm-dd format for the database and would like to be able to call the current day's event, show,etc. on the main page of the site.

So if I had dates 2003-04-09 through 2003-04-30 listed in the database, when a user came to the site on 2003-04-10 it would extract the show corresponding to the current date and print only the one show. something like...Show Tonight @ Timbuk 9 or of no show was happening it wouldn't print anything.

Is there a way to do this? Any help would be greatly appreciated.

Thanks,
Ghengis

cyclops

Play around with this :

SELECT * FROM `database`.`table`
WHERE 'datefield' BETWEEN '$startdate' AND '$enddate'

zurron

and why dont you just extract the date from de data base with a SQL query.
I don't know which data base you are using but the sql query could be like this:

/* FUNCTION GET DATE RETURN TEH DATE WITH THE FORMAT REQUIERED*/
function get_date(){
$today = date("Y-m-d");
return $today;
}/* END FUNCTION GET DATE */

$query="SELECT * FROM your_table WHERE the_date_field='$today'";

cahva

Or even better, why use php to get the date when you can get it straight in your query:

$query="SELECT * FROM your_table WHERE the_date_field=CURDATE()";

ghengisape

I'll try all of these out just to see what does what tomorrow night (I'm crashing hard tonight) and get back.

Thanks again.

Ghengis