> I have a small but hard to solve problem to solve. > Wrote a Select Query for my webpage. > The query should select all values which where > written into the DB the last seven Days. > I thought everything was working fine, but now > the month has changed and everything went > wrong. > My Select Query is not able to go into the Last > month in calculation. > I don't really know how to manage this problem. > Here is the Query: > $Query = "SELECT * FROM bild_db WHERE datum > '".date('Y') . '-' . > date('m') . '-' . (date('d') - $_REQUEST['days']) . ' 00:00:00'."'";
SELECT * FROM bild_db WHERE datum BETWEEN NOW() AND NOW() - INTERVAL 7 DAY; ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php