> > I have been trying to find a way to search a DB and match a > range within a > week ( php & mysql ). > > This doesn't make sense, so I will describe it in more detail. > > > > Hi everyone, > > I need help with a search, lets say a record has a date of > 2/5/2007 and if > someone visits the website between 2/5/07 and 2/11/07 I want > to display the > record with 2/5/2007. > > If it's within the week so to speak. > > > > Does anyone know how I can accomplish this? >
(You might get better answers from the MySQL list when asking MySQL questions.) SELECT * from table where record_date between '$begin_date' and '$end_date'; JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
