What's that <<< END on the end of $query all about? And would LIMIT 0,7 grab the 7 records following the one tested with WHERE NOW() BETWEEN start_time AND end_time??
The table is set up with these fields, with a sample entry at the end of each line after the ...
id(TINYINT) set to autoincrease...1
start_time(INT)...600
end_time(INT)...660
time_label(TEXT)...10:00am
name(TEXT)...Event Name
image(TEXT) it's URL information...images/event1.gif
info_link(TEXT) it's also URL information...events/event1.htm
And the results would be used in a fairly straightforward way, embedded in certain cells of an HTML table:
PHP Code:
echo("<td>".$time_label[0]."</td>");