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:mdemirkus@momentum-dmt.com] Sent: Thursday, September 19, 2002 8:36 AM To: mysql@lists.mysql.com; php-db@lists.php.net 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