Select query between a few hours.

[djpaul]

Hello guys,
I'm busy writing a website for dj's.
But i wanted to show the picture and more stuff of the dj who's playing music between a few hours.
Let's say he works between 18:00 and 21:00 on wednesday.
I created a table begin_time and a table end_time and day.
Then i wanted to compare the times with the local time like[PHP]$time = date("H");[/PHP]
[PHP]$day = date("l");[/PHP].
I thought something like this query:

[PHP]$query = "SELECT * FROM dj WHERE day='{$day}' AND begin_time='{$time}'=BETWEEN begin_time AND end_time";[/PHP].

But i can't figure it out....
The problem is that the time only compares at that hour (eg 18:00 and 21:00) but when it is 20:00 he doesn't recognize it.(logical of course...)
But how can i let it work like this...

Thanx in advance!

Paul

[pbmods]

Hello guys,
I'm busy writing a website for dj's.
But i wanted to show the picture and more stuff of the dj who's playing music between a few hours.
Let's say he works between 18:00 and 21:00 on wednesday.
I created a table begin_time and a table end_time and day.
Then i wanted to compare the times with the local time like[PHP]$time = date("H");[/PHP]
[PHP]$day = date("l");[/PHP].

Take a look at CURDATE() and CURTIME(). You can also use NOW(), which returns a timestamp, so you can use it for both dates and times.