Timothy Wright wrote:
> Just wondering...
>
> DATE_FORMAT($datevariable, \"%Y%c%e\") works great in a query but I only
> need to list the date once on the page (as opposed to in each row of the
> query result) and I don't want to use a second query to MySQL. The date is
> passed to the page as a variable in YYYYmd (month and day as integers)
> format.
>
> Any help greatly appreciated...
>
> Tim
>
> :::::::::::::::::::::::::::::::::::::::::::
> ::: :::
> ::: Timothy Wright :::
> ::: mailto:[EMAIL PROTECTED] :::
> ::: Digital Network Enterprises :::
> ::: http://www.01network.com :::
> ::: :::
> ::: secure e-mail by request :::
> ::: (PGP signature and/or encryption) :::
> :::::::::::::::::::::::::::::::::::::::::::
>
> --
> 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]
Yes. Take a look at http://www.php.net/manual/en/function.date.php
You're Welcome
DM
--
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]