stupid error, I can't find it!

VooDooRT

I'm getitng this error:

UPDATE auth SET recruit = "15", award_medal = "16", award_moh = "14", ban_ip = "12", edit_info = "0", edit_pass = "20", change_rec = "1", del_news = "9", newsletter = "6",
diplomacy = "6", demote = "20", disable = "6", news = "6", mod_recruiting = "20", obtain_pass = "16", promote_gen = "",
promote = "20", change_name = "20", prot_edit = "20", purge = "20", rem_medal = "20", set_days = "20", set_rank = "20",
unban_ip = "19", undisable = "20", view_ips = "20"

1064: You have an error in your SQL syntax near 'purge = "20",
rem_medal = "20", set_days = "20", set_rank = "20", unban_ip = "19' at line 1

Here is the code:

if($cmd == '_auth'){
$sql = "UPDATE auth SET recruit = \"$recruit\", award_medal = \"$award_medal\", award_moh = \"$award_moh\", ban_ip = \"$ban_ip\", edit_info = \"$edit_info\",
 edit_pass = \"$edit_pass\", change_rec = \"$change_rec\", del_news = \"$del_news\", newsletter = \"$newsletter\", diplomacy = \"$diplomacy\", demote = \"$demote\", disable = \"$disable\", news = \"$news\",
 mod_recruiting = \"$mod_recruiting\", obtain_pass = \"$obtain_pass\", promote_gen = \"$promote_gen\", promote = \"$promote\", change_name = \"$change_name\",
 prot_edit = \"$prot_edit\", purge = \"$purge\", rem_medal = \"$rem_medal\", set_days = \"$set_days\", set_rank = \"$set_rank\", unban_ip = \"$unban_ip\",
 undisable = \"$undisable\", view_ips = \"$view_ips\"";
				mysql_query("$sql") or die ("<p>$sql<P>".mysql_errno().": ".mysql_error());
		echo("
			<center>$fontString
		<META HTTP-EQUIV=\"Refresh\" CONTENT=\"3; URL=main.php\"> 
			You have updated the site authorizations.  Please stand-by while you are forwarded back to your console.
			");
}

Someone PLEASE tell me where my error is? I don't see no stupid parse error! Syntax my butt! ARGH!

VooDooRT

I checked the SQL database and everything there is good to go. No typos in the names or anything like that.

Please? This is really irritating me...ugh

Duey

ill tell you what it is if you make clantek free 🙂

VooDooRT

lol, what does that have to do with anything? And who are you?

Duey

😮 im jesus 🙂 (not really) i just dont think you should be selling that considering you ripped those images, and there are better ones out there, the SQl query umm how many rows are in the auth table

VooDooRT

ripped the images? Dude...

1) I'm in the Air Force.
2) The images came from the Air Force home page as "free source"
3) 1 row, 26 fields

Duey

meh i was only stuffing with you, hmm what if you stick another field like id or something witha value of 1 and stick WHERE id = '1' at the end 🙂

VooDooRT

Here's a dump from the table:

CREATE TABLE auth (
recruit text NOT NULL,
award_medal text NOT NULL,
award_moh text NOT NULL,
ban_ip text NOT NULL,
edit_info text NOT NULL,
edit_pass text NOT NULL,
change_rec text NOT NULL,
del_news text NOT NULL,
newsletter text NOT NULL,
diplomacy text NOT NULL,
disable text NOT NULL,
news text NOT NULL,
mod_recruiting text NOT NULL,
obtain_pass text NOT NULL,
promote_gen text NOT NULL,
promote text NOT NULL,
change_name text NOT NULL,
prot_edit text NOT NULL,
purge text NOT NULL,
rem_medal text NOT NULL,
set_days text NOT NULL,
set_rank text NOT NULL,
unban_ip text NOT NULL,
undisable text NOT NULL,
view_ips text NOT NULL,
demote text NOT NULL
) TYPE=MyISAM;

Dumping data for table `auth`

INSERT INTO auth VALUES ('15', '16', '14', '12', '0', '20', '1', '9', '6', '6', '6', '6', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20');

VooDooRT

I only need the one row. It's just something that gets updated when people set the authorizations for the website. No need for an ID I wouldn't think...or am I wrong???

Duey

why are they all texts? make them tinyint or int or varchar(10) or something text isnt really appropriate

VooDooRT

changed all to varchar(2) and same error....ugh

Duey

k leave it as varchar and make an id field

VooDooRT

same error, but how is all that supposed to help a SYNTAX error? This is really weird...

Duey

mysql syntax errors are like php parse errors unpredictable 🙂 well i looked through everything i cant find a thing mabe stick a ";" at the end?

VooDooRT

if($cmd == '_auth'){
$sql = "UPDATE auth SET 
			recruit = \"$recruit\", 
			award_medal = \"$award_medal\", 
			award_moh = \"$award_moh\", 
			ban_ip = \"$ban_ip\", 
			edit_info = \"$edit_info\", 
			edit_pass = \"$edit_pass\", 
			change_rec = \"$change_rec\", 
			del_news = \"$del_news\", 
			newsletter = \"$newsletter\", 
			diplomacy = \"$diplomacy\", 
			demote = \"$demote\", 
			disable = \"$disable\", 
			news = \"$news\", 
			mod_recruiting = \"$mod_recruiting\", 
			obtain_pass = \"$obtain_pass\", 
			promote_gen = \"$promote_gen\", 
			promote = \"$promote\", 
			change_name = \"$change_name\", 
			prot_edit = \"$prot_edit\", 
			purge = \"$purge\", 
			rem_medal = \"$rem_medal\", 
			set_days = \"$set_days\", 
			set_rank = \"$set_rank\", 
			unban_ip = \"$unban_ip\", 
			undisable = \"$undisable\", 
			view_ips = \"$view_ips\"";
				@mysql_query("$sql") or die ("<p>$sql<P>".mysql_errno().": ".mysql_error());

As you can see, it's there....

Duey

o heres an error mysql_query("$sql") should be mysql_query($sql)

diego25

VoodooRt, can you do a
print $sql;

and post the result here? Maybe one of your variables has something that should be escaped with addslashes().

Diego

VooDooRT

didn't work...poop

Duey

he has, if you look at his code it prints the query before the error and he has posted the error att he top

VooDooRT

Here's the echo of SQL on the error

UPDATE auth SET recruit = "15", award_medal = "16", award_moh = "14", ban_ip = "12", edit_info = "0", edit_pass = "20", change_rec = "1", del_news = "9", newsletter = "6", diplomacy = "6", demote = "20", disable = "6", news = "6", mod_recruiting = "20", obtain_pass = "20", promote_gen = "", promote = "20", change_name = "20", prot_edit = "20", purge = "20", rem_medal = "20", set_days = "20", set_rank = "20", unban_ip = "20", undisable = "20", view_ips = "19"