Help with displaying todays dates

[gin0115]

Dont suppose any one could give a PHP newbie a hand could they?

I have made a small php gig guide but am finding it hard to find out how to run a query based on todays date

I have the day, month & year stored in seperate rows. can i over come this using php or wouild i have to use Javascript?

my query so far is

$query = "SELECT id, venue, band1, band2, band3, band4, band5, cost, time FROM guests WHERE day='10' ORDER BY day ASC";

also is there any way to set a second "WHERE" variable to the query?

[vincevincevince]

WHERE day='10' AND month='2' AND year = '2005'

[ReveL]

make it dynamic:

$query = "SELECT id, venue, band1, band2, band3, band4, band5, cost, time FROM guests WHERE day=DAYOFMONTH(NOW()) AND month=MONTH(NOW()) AND year=YEAR(NOW()) ORDER BY day ASC";

it will always pick todays date.

[vincevincevince]

If it were me I'd have stored it as a timestamp in the first place...

[mogenshoj]

I would use time() for getting dates.

You can always get todays date with:
$today = mktime(0, 0, 0, date("n"), date("j") , date("Y"));

You need to insert it this way too.

It would be easier if you later choose to select data from the last xx days.