Or this works well too and might be faster for the DB.

SELECT * FROM SomeTable WHERE create_date BETWEEN $start_date AND
$end_date

 

> -----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

Reply via email to