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

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 starts at 0 and is incremented and $from_date is the date you wish to start out with: SELECT col_1, col_2 FROM table_name WHERE date_col = DATE_ADD("$from_date", INTERVAL $loop DAY) I'm sure there are at least a dozen other ways to attack this, hopefully these will give you something to work with and are perhaps helpful. Enjoy! Tyrone -----Original Message----- From: Marc Johnson [mailto:metman@metman.com] Sent: Tuesday, May 15, 2001 4:19 PM To: php-db@lists.php.net Subject: [PHP-DB] Trying to pull a weeks worth of data of a DATE entry 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 many websites) and having that header appear only once per days worth of 'news'. Not really sure where to start considering I have only been at this for two days. My scripting skills are limited so far so I am sure that the approach I am taking is the hard way. Can anyone provide me with a link to examples of this code (the actual code) so I can see how it has been done? Or perhaps if its a easy solution (i.e. SELECT date "(from date to date)" type command). I have seen examples of sorting by date and munipulation of the date via SELECT, but cant seem to pinpoint how to extract only from-to dates. Even if I can use a SELECT command where date = x would work. Any help, or pointing in the right direction would be greatly appreciated (and probably save money on my Rogain bills). Thanks, Seriously Confused in Seattle, Marc I have tried multiple attempts at some variation of: $week_var = 7; $tdate = getdate(); $yday_var = $tdate['yday']; $wdate = $yday + $week_var; Granted -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net