插入数据库php变量

Question

I have got this code:

$title = mysql_real_escape_string($_POST['title']);
$description = mysql_real_escape_string($_POST['description']);
$method = mysql_real_escape_string($_POST['method']);

$method1 = '<ul><li>' . implode('</li><li>', explode("
", $description)) . '</li></ul>';


mysql_query("INSERT INTO recipe (title, description, method) VALUES('".$title."', '".$description."', '".$method1."')");

But it isnt adding anything to my database. Should this code be working?

UPDATE***

I have added the following code but it is not outputing anything

if($success)
{
echo "<h1>Success</h1>";
}
else
{
echo "<h1>Error</h1>";
}

Answer 1

try to wrap your fields with ''

"INSERT INTO recipe (`title`, `description`, `method`) VALUES('".$title."', '".$description."', '".$method1."')");

look on reserved words