[SOLVED] date returned from mysql

[cleary1981]

Hi

 

Im having a problem with the date format mysql has returned. It returns dates in the format yyyy-mm-dd.

I want to diplay this as dd-mm-yyyy. Has anyone got an easy method for converting this in php?

[kenrbnsn]

If you want to do this in PHP do:

<?php
$display_date = date('d-m-Y',strtotime($mysql_data));
?>

 

Ken

[cleary1981]

Im not quite sure how I would implement this. Heres the code I have

 

<?php
require "config.php";

$proj = $_REQUEST['proj'];
$sql = "SELECT * FROM project WHERE project_name='$proj'";
$result = mysql_query($sql) or trigger_error(mysql_error());
$row = mysql_fetch_assoc($result);

$return = $row['proj_id']."%". $row['project_name']."%". $row['form']."%". $row['access']."%". $row['cable_entry']."%". $row['ip_rating']."%". $row['fault_rating']."%". $row['company_name']."%". $row['proj_manager']."%". $row['deadline'];

echo $return;
?>

 

$row['deadline'] contains the date that I want to format.

[revraz]

$return = $row['proj_id']."%". $row['project_name']."%". $row['form']."%". $row['access']."%". $row['cable_entry']."%". $row['ip_rating']."%". $row['fault_rating']."%". $row['company_name']."%". $row['proj_manager']."%". date('d-m-Y',strtotime($row['deadline']));