SELECT * FROM table1
WHERE YEAR(datefield1) = 1999
check datetime functions @ http://www.mysql.com/documentation
"Andrew.Martin" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I want to check the date of numerous records in many DB tables, I have
tried
> using the
> date (Ymd); function but it doesn't appear to work, not sure whats going
> wrong.
>
> I set a variable based on this function and use this variable within the
> select statement!
> Anyone know whats happening or if there is a descent solution available?
>
> thanks,
>
> Andrew
>
--
PHP Windows 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]
