[RESOLVED] SQL Update error

JeremyTiki

Im trying to create a update statement using php to update a clients profile.

$sql_insert = "UPDATE company 
					SET owner = '$owner' , street_ad = '$street_ad' , state = '$state' ,  zip = '$zip' ,  email = '$email' ,  phone = '$phone' , desc = '$desc' 
					WHERE company_name = '$company' ";

			$result_insert= mysql_query($sql_insert);

				 if(!$result_insert)
				 {
				 die ("Error on insert: " . mysql_error());
				 }

This is the actual statment. I checked all the variable names and colum names to make sure it wasnt a spelling mistake but Im still getting this error "Error on insert: 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 = 'Test' WHERE company_name = 'Tiki Website Productions'' at line 2"

Does anyone have an suggestions?

bradgrafelman

Welcome to PHPBuilder!
When posting PHP code, please use the board's [noparse]
```
..
```
[/noparse] bbcode tags as they make your code much easier to read and analyze.
"DESC" is a reserved word in MySQL. Best practice is to avoid using reserved words as identifiers completely; if you must use them, then you should surround them with backticks (`) to indicate that you're using an identifier and not the reserved word.

JeremyTiki

bradgrafelman;10951877 wrote:
1. Welcome to PHPBuilder!
When posting PHP code, please use the board's [noparse]
..
[/noparse] bbcode tags as they make your code much easier to read and analyze.
"DESC" is a reserved word in MySQL. Best practice is to avoid using reserved words as identifiers completely; if you must use them, then you should surround them with backticks (`) to indicate that you're using an identifier and not the reserved word.

Thank you everythings working now!
And sorry this was my first time posting so I didnt know

bradgrafelman

You're welcome. Don't forget to mark this thread resolved using the link on the Thread Tools menu.