Re: searching date
| From: | Kae Verens | Date: | Fri, 15 Aug 2003 06:39:01 +0000 |
| Subject: | Re: searching date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-159642@lists.php.net to get a copy of this message | ||
Bl1412@Hotpop wrote:
Hi , 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$q=mysql_query('select * from news wherenewsWHEREdateincluded in ($date_begin & $date_last)"
date >= "'.$date_begin.'" and date < "'.$date_last.'" + interval 1 day');
you should rename the field you have called date - it's ambiguous.
Kae