Stupid Parse Error

Napster

I am getting this stupid parse error for this code

if ($action == "insert" AND $row["num_users"] == "0")
{
$query = "INSERT INTO stats (username,str,int,wis,cha,con,dex) VALUES ('$username','$str','$int','$wis','$cha','$con','$dex')";
mysql_query($query) or die (mysql_error());
echo "You know have your stats, good luck";
die();
}

more specifically

$query = "INSERT INTO stats (username,str,int,wis,cha,con,dex) VALUES ('$username','$str','$int','$wis','$cha','$con','$dex')";

The error I get is:
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 'int,wis,cha,con,dex) VALUES ('test','13','11','7','15','16','11

All those variables are random numbers and the table name is right.

drawmack

int is a reserved word in mysql why don't you try using intelligence for the column name instead.

Napster

Ok Thanks

Napster

ok i renamed the column to int2 and i still get an error

Weedpacket

Er, maybe you should have quoted that name, drawmack....

drawmack

nah I'll just look through the finished product and report any ogl violations I find 😉

what error are your getting now?

Napster

it is almost the same as the error above it says

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 'int2,wis,cha,con,dex) VALUES ('test','13','11','7','15','16','11

stolzyboy

ummm try only having one space after VALUES

Napster

it still doesnt work

stolzyboy

do you have word wrap on in your editor, if so, try making it all one line

also do

echo $query;

right after the $query = "blah, blah";

line to see what the whole query comes out as, then post that back...

Napster

here is the echo

INSERT INTO stats (username,str,int2,wis,cha,con,dex) VALUES ('test','11','8','8','10','10','7')

and the error is 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 'int2,wis,cha,con,dex) VALUES ('test','11','8','8','10','10','7'

i have no word wrap

pjleonhardt

perhaps im wrong, but arent you sposed to have a ; after a sql query? or is that just for multiple queries

stolzyboy

Originally posted by pjleonhardt
perhaps im wrong, but arent you sposed to have a ; after a sql query? or is that just for multiple queries

usually, could be the problem in this case, but sometimes (unknown why) isn't required...

ahundiak

Post the results of "DESCRIBE TABLE stats". I think you still have a mismatch between your insert column names and the table itself.

Napster

that is not the problem, i checked that first, to see if i named the columns wrong.

kellog

What types are all the colums other than username? If they are set to be a number, then try:

$query = "INSERT INTO stats (username, strength, intel, wis, cha, con, dex) VALUES ('$username',$strength, $intel, $wis, $cha, $con, $dex)";

Napster

i will post the info on the table

username varchar(20)
str int(2)
int2 int(2)
wis int(2)
cha int(2)
con int(2)
dex int(2)

there is no other columns