Select * from Table where MONTH(date) = $current_month;
--- In [email protected], owaiZ Vaiyani <[EMAIL PROTECTED]>
wrote:
> hi
> i would like to know how to retrieve month from a date
> field
>
> i have a table in mysql where there is a field date in
> this form YYYY-MM-DD
> now using php i want to retrieve date where month is
> same as current month
>
> Select * from Table where date = $current_month;
>
> is it possible this way ?
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Personals - Better first dates. More second dates.
> http://personals.yahoo.com
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
