Forum Moderators: coopster
$startdate = explode("-",$row['arr_date']);
$styear = $startdate[0];
$stmonth = $startdate[1];
$stday = $startdate[2];
if the date in the db was 2008-03-11
$styear would be 2008. how can i make it 08?
Im not 100% on how mktime or strtotime works, and i think it might be one of those...
$styear = substr [php.net]($startdate[0], 2, 2);
$sql = "SELECT SUBSTRING('2008-03-06', 3) AS yymmdd";
$rows = mysql_query($sql);
$row = mysql_fetch_array($rows);
list [php.net]($yy, $mm, $dd) = explode('-', $row['yymmdd']);
print "$mm/$dd/$yy";
exit;