How to convert MySQL date to a dif format

Duxie

I'm pulling the data from a database to use in an array:

$sqlT = "SELECT * WHERE in_date = \"$today\" AND cat1 = \"T\" Order by title";
			$sql_resultT = mysql_query($sqlT,$connection);

Using the following array:

while ($row = mysql_fetch_array($sql_resultT)) {
	$id = $row["id"];
	$title = $row["title"];
	$price = $row["price"];
	$disc = $row["disc"];
	$date = $row["date"];
	if ($date <= 0){
	$month = "reorder";
	} else {
	$month = $date;
	}
	echo "
			  <tr>
                <td>$title</td>
                <td><div align=\"center\"> $price </font></div></td>
                <td><div align=\"center\"> $disc </font></div></td>
				<td><div align=\"center\"> $month </font></div></td>
              </tr>

";
}
}

I'd like to have "date" formated as mm/yy in stead of the default yyyy-mm-dd.
Hope this is clear enough.

LordShryku

Couple ways you could do it. Format it in your query: http://www.mysql.com/doc/en/Date_and_time_functions.html , also search this site. Lots of threads like this...

Or format it in PHP. Something like

while ($row = mysql_fetch_array($sql_resultT)) { 
   $id = $row["id"]; 
    $title = $row["title"]; 
    $price = $row["price"]; 
    $disc = $row["disc"]; 
    $date = $row["date"]; 
    if ($date <= 0) { 
        $month = "reorder"; 
    } 
    else { 
        $month = date("m/y", strtotime($date)); 
    }

Duxie

Ahh....
All bask in the wizdom of LordShryku.
(PHP Fix)
Works Perfect!
Many thanks.