Re: Date function.
| From: | Marcelo Gulin | Date: | Fri, 19 Jan 2001 18:24:08 +0000 |
| Subject: | Re: Date function. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5997@lists.php.net to get a copy of this message | ||
Hi Sharif!
try...
$date1 = "2001-07-01";
$date2 = "2001-07-31";
$query = "SELECT * FROM table WHERE birthdays BETWEEN $date1 AND
$date2";
regards
Marcelo Gulin
Sharif Islam escribió:
>
> This is a simple mysql question i am having problme with.
> I have a table with name and birth date;
>
> --------------------
> Joe | 1964-07-21
> Mary | 1978-05-22
> --------------
> I want to get the name with birthdays in the month of July.
> thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net