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
$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"]
I've never used to DATE_FORMAT in a select statement, in inserts it makes sense, but why don't you just grab the content and let PHP do the formatting with [php_man]date[/php_man]?
$SQL="SELECT DATE_FORMAT(dob,'%D %M %Y') as dob from members WHERE idnum=$id";
$result=mysql_query($SQL,$dB);
$row = mysql_fetch_array($result);
$dob = $rowї"dob"];