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