TalkPHP - View Single Post

Alan @ CIT · 02-14-2008, 01:26 AM

Tip: you can use the [ php ][ /php ] tags to save having to manually color your code when posting

The query in the script you posted is in the wrong format. You have mixed up INSERT and UPDATE syntax.

An INSERT query should look something like:

PHP Code:


			
$query = "INSERT INTO table (column1, column2, etc) VALUES ('value1', 'value2', 'etc')"

An UPDATE query should look something like:

PHP Code:


			
$query = "UPDATE table SET column1 = 'value1, column2 = 'value2, etc = 'etc' WHERE something = 'else'"

Alan

02-14-2008, 01:26 AM	#14 (permalink)
Alan @ CIT Member of the Month The Frequenter Join Date: Apr 2005 Location: South UK Posts: 483 Thanks: 51	Tip: you can use the [ php ][ /php ] tags to save having to manually color your code when posting The query in the script you posted is in the wrong format. You have mixed up INSERT and UPDATE syntax. An INSERT query should look something like: PHP Code: `$query = "INSERT INTO table (column1, column2, etc) VALUES ('value1', 'value2', 'etc')"` An UPDATE query should look something like: PHP Code: `$query = "UPDATE table SET column1 = 'value1, column2 = 'value2, etc = 'etc' WHERE something = 'else'"` Alan