RE: [PHP] searching date
| From: | Jay Blanchard | Date: | Thu, 14 Aug 2003 20:41:57 +0000 |
| Subject: | RE: [PHP] searching date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-159617@lists.php.net to get a copy of this message | ||
[snip]
The user have to choose 2 date ($date_begin & $date_last) and i want
to know howcan i make to find field in mysql where field included
between ($date_begin & $date_last)
"SELECT * FROM
news WHERE date included in ($date_begin
&
$date_last)"
[/snip]
This is better suited to the mysql list, but you could do ...
"SELECT * FROM news WHERE date BETWEEN $date_begin AND
$date_last "
HTH!