[PHP-DB] Trying to pull a weeks worth of data of a DATE entry

2001-05-15 Thread Marc Johnson
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

RE: [PHP-DB] Trying to pull a weeks worth of data of a DATE entry

2001-05-15 Thread Tyrone Mills
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