DATE_format
Posted: Tue Mar 09, 2004 12:02 pm
I am using this so I can display a DATE type in a nice fashion.
I have the sql syntax working in mysql
However I am unsure how to retrieve it in php..
I have
I have the sql syntax working in mysql
However I am unsure how to retrieve it in php..
I have
Code: Select all
$SQL="SELECT DATE_FORMAT(dob,'%D %M %Y')from members WHERE idnum=$id";
$result=mysql_query($SQL,$dB);
$row=mysql_fetch_array($result);
$dob=rowї"dob"]