RE: [PHP-DB] how can I do?
| From: | Jackson Miller | Date: | Thu, 19 Sep 2002 13:23:14 +0000 |
| Subject: | RE: [PHP-DB] how can I do? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21848@lists.php.net to get a copy of this message | ||
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:aaronjw@martekbiz.com]
> Sent: Thursday, September 19, 2002 7:31 AM
> To: 'Meltem Demirkus'; mysql@lists.mysql.com; php-db@lists.php.net
> 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: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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>