[SOLVED] INSERT Trouble

[iceblox]

Hi Guys,

 

I have a simple form that i seem to be having issues with and I cant see why it isnt working.

 

This is the error i get

 

Array ( [message] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, url, clickurl) VALUES ' at line 1 [code] => 1064 ) array(2) { ["message"]=> string(226) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, url, clickurl) VALUES ' at line 1" ["code"]=> int(1064) } bool(true) 

 

 

and this is the insert code

 

	if(!empty($_POST["addbutton"]))
{
	$result = $db->sql_query("INSERT INTO google (title, desc, url, clickurl) VALUES 
                                                     ('".forSql($_POST["title"])."', '".forSql($_POST["desc"])."', '".forSql($_POST["url"])."', '".forSql($_POST["clickurl"])."')");
	if($result)
		$status = "<b>".$_POST["title"] . " added successfully</b>";
	else
	{
		print_r($db->sql_error($result));
		$status = "<b>Error could not add banner. " . var_dump($db->sql_error($result),true);
	}
}

 

Any ideas?[/code]

[Gamic]

Desc is a keyword in mysql. Either change the name of that field or use ' marks around it.

[iceblox]

Ah, i dsisnt realise that..

 

Thanks very much Gamic, works now 

 

Cheers