Or this works well too and might be faster for the DB. SELECT * FROM SomeTable WHERE create_date BETWEEN $start_date AND $end_date
Advertising
> -----Original Message----- > From: Aaron Wolski [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 7:31 AM > To: 'Meltem Demirkus'; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] how can I do? > > > SELECT * from SomeTable where dateinserted>$start_date AND > dateinserted<$end_date > > Dateinserted is the date stamp column in your table. > > Aaron > > -----Original Message----- > From: Meltem Demirkus [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 8:36 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] how can I do? > > > I am trying to find the records whose create dates (field name > =create_date) are between the ones I want .For example , I > want to seee the records between $start_date and $end_date > ..So I tried the code below..But it looks not that right to me?... > > select * from bug where ...... and "$start_date < create_date< > $end > _date > > > Can any body help?.. > > thanks alot .. > meltem demirkus > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
