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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]