Re: [PHP-DB] DATE_FORMAT From: Bogdan Stancescu (mgv <email protected>)
Date: 06/25/02

Seth Yount wrote:

> Hello all...
>
> does anyone know if you can select more than one colemn when using
> the DATE_FORMAT command...
>
> $sdate_query = mysql_query("SELECT DATE_FORMAT(StartDate, '%M %d %Y')
> FROM Events
> WHERE Event_ID = '$Event_ID'
> ");
>
> ... Could I have another ColumnName after StartDate such as EndDate.
> I get an error when I try but I haven't been trying to hard to find a
> way to do this.

Obviously.

$sdate_query = mysql_query("SELECT DATE_FORMAT(StartDate, '%M %d %Y'),
DATE_FORMAT(EndDate, '%M %d %Y')
                FROM Events
                WHERE Event_ID = '$Event_ID'
               ");

Bogdan 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php