[jeddi]

So my query is :

PHP Code:

$sql = "SELECT * FROM pages WHERE page_id = $Db_page_id AND client_no = '$this_client' "; 


So if I want to include

DATE_FORMAT(pub_date, '%m/%d/%Y') AS formattedDate

then I'll have to list all the records I guess ??
( there are about 18 of them )

It seems to me it would be nicer to just reformat the result for that record.

Something like :

PHP Code:

$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date     = date("m/d/y", $N_pub_date); 


Can it not be done with php ??

Thanks.


.