I have read through some old posts regarding date formatting from MySQL table and also read a bit of the PHP manual.
I cam up with the follwoing that I thought would work.
//The below is my SQL statement to fetch the data and format the date
Code: Select all
$sql = "SELECT tid, title, bodytext, DATE_FORMAT(modification_date,'%d %m %Y'), counter, product FROM tech_notes WHERE tid = '$id'";Code: Select all
echo "<td width="25%">$dataїmodification_date]<br>$dataїproduct]<br>$dataїcounter] views</td>";Any help is appreciated.