I am trying to pull a weeks worth of data from MySQL from a DATE var field.
Which in turn I can seperate to each days 'entries' sorted by date AND time.
Basically trying to set up a page to pull 'news entry date' sorted by date
and time, with each
day having its own header (like you see on so
Hi Marc,
If I understand your question correctly, the SQL Syntax you might want to
try would be:
SELECT col_1, col_2 FROM table_name WHERE date_col = $from_date AND
date_col = $to_date
Or if you want to get each days results individually, you could do something
like this in a loop, where $loop