- Time Management -

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

Post Reply
User avatar
Redcircle
Moderator
Moderator
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Post by Redcircle » Sun Sep 07, 2003 11:13 am

Somethign like
$current_time = //current time of day since 12am
//start_time would be seconds since 12am
//length would be in seconds
$query = 'select * from classes left join class_time on classes.class_id = class_time.class_id where start_time > "'.$current_time.'" and (start_time+length)< '".$current_time.'" order by start_time asc';

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest