My code goes like this:
echo "<td width='40%' align='right'><font face='Arial' size='2'>Submission Date and Time</font></td>\n";
$rfq_date = mktime(substr($row["date"], 11, 2), substr($row["date"], 14, 2), substr($row["date"], 17, 2), substr($row["date"], 5, 2), substr($row["rfq_date"], 8, 2), substr($row["rfq_date"], 0, 4));
echo "<td width='60%'><font face='Arial' size='2'>".date("D d F Y H:i:s",$rfq_date)."</font></td>\n";
echo "</td>\n";
i declare $rfq_date in mysql as datetime.
Then why does when i retrieve the date, it gives me this date, Wed 31 December 1969 15:59:59, always the same date not the date of my system clock.
Please help me fix this, Thanks...
