SQL Query

neXGen

Hey guyes!
Can someone help me out with this SQL query? I keep getting an error from it.

			<?
	# this is processed when the form is submitted
	# back on to this page (POST METHOD)
	if ($REQUEST_METHOD=="POST") {

	# setup SQL statement
	$SQL = " UPDATE characters WHERE cID='$id' AND Author='$cookie[0]' SET Name='$Name', PvPtitle='$PvPtitle', Title='$Title', Division='$Division', Prof='$Prof', Breed='$Breed', Level='$Level', Description='$Description', Pros='$Pros', Cons='$Cons', Bio='$Bio', pic='$pic', ingamepic='$ingamepic' ";

	#execute SQL statement
	$result = mysql_db_query($db,"$SQL",$cid);

	# check for error
	if (!$result) { echo ("<B>ERROR:</B><br> " . mysql_error() . "\n$SQL\n");	} else {

	echo ("<P><B><h6>The details on character $Name was updated successfully!</h6></p>\n"); }
}

sid

what error do you get?

are the variables spelled correctly and actually in the database? are the variable types correct?

neXGen

This is the error I get:

You have an error in your SQL syntax near 'WHERE cID='1' AND Author='neXGen' SET Name='Dark Angel ', PvPtitle='', Title='Ge' at line 1 UPDATE characters WHERE cID='1' AND Author='neXGen' SET Name='Dark Angel ', PvPtitle='', Title='General', Division='Administration', Prof='Nano-Technician', Breed='Homo-Nano Male', Level='111', Description='This is a description of Xephiroth. It contains lots of exciting stuff', Pros='He roxxor your boxxors', Cons='He is silly as hell with low hp', Bio='Bio will go here. You can even use HtMl! 
<br>
See?', pic='http://www.anarchy-online.com/character/photos/40191.jpg', ingamepic='http://www.anarchy-online.com/content/game/shadowlands/globalShadowGFX/shadowBreed.jpg'

Yes, all the values are in the database. Is there something wrong with my sql statement?

Check the page out for yourself here

Lars_Berg

$SQL = " UPDATE characters  SET Name='$Name',      

PvPtitle='$PvPtitle', Title='$Title',  Division='$Division', 
Prof='$Prof',  Breed='$Breed', Level='$Level', 
Description='$Description', Pros='$Pros', Cons='$Cons', 
Bio='$Bio', pic='$pic', ingamepic='$ingamepic' 
WHERE cID='$id' AND Author='$cookie[0]'";

sid

oh man... that was too obvious... spank

neXGen

No wonder why I could'nt find out of it!

Tusen takk Lars!