store commas in mysql database

ananetre

New Member
I'm trying to store the date in an sql table, but I want it formatted as such:Month day, yearOctober 10, 2010But whenever I do the sql call, the 2010 gets lost. How can I fix this?\[code\]$eventdate = "October 10, 2010";$sql = "INSERT INTO `tims`.`blog` ( `title`, `date`, `post`, `author`, `approved`) \n" . "VALUES ( '" . mysql_real_escape_string($_REQUEST['title']) . "', '" . mysql_real_escape_string(addslashes($eventDate)) . "', '" . mysql_real_escape_string($_REQUEST['TextArea1']) . "', '" . mysql_real_escape_string($_REQUEST['author']) . "', 'False')\n";//echo $sql;$qry = mysql_query($sql) or die(mysql_error());\[/code\]
 
Back
Top