cant find parse error

[TheBW]

heres the part of script that has parse error. Im not that good with mysql yet, but i cant seam to find the error in there, looks pretty much like examples i am learning from.

if ($itemtype != 0){ //line 116
	mysql_query("INSERT INTO {{table}} SET id="", playername="$playername", itemtype="$itemtype", quality="$quality", itemlvl="$data['itemlvl']", minwdmg="$data['minwdmg']", maxwdmg="$data['maxwdmg']", ar="$data['statAR']", statt1="$data['statt1']", stat1="$data['stat1']", statt2="$data['statt2']", stat2="$data['stat2']", items") or die(mysql_error());  

	}

Any ideas?

Parse error: parse error in C:\wamp\www\Game\itemgen.php on line 117

[tommyrulez]

Not sure why you have {{}}, also it should be SET id ="" WHERE playername="$playername"
Don't forget to use something like htmlentities to clean the user input before putting it into the database.

mysql_query("INSERT INTO {{table}} SET id="", playername="$playername", itemtype="$itemtype", quality="$quality", itemlvl="$data['itemlvl']", minwdmg="$data['minwdmg']", maxwdmg="$data['maxwdmg']", ar="$data['statAR']", statt1="$data['statt1']", stat1="$data['stat1']", statt2="$data['statt2']", stat2="$data['stat2']", items") or die(mysql_error());  

    } 

[TheBW]

No, its supposed to add new line in table not insert information. Script creates unique items, so all information should just be inserted.

[halojoy]

You are using the UPDATE format with SET

For adding a new row
INSERT INTO is like this

<?php

$sql = "INSERT INTO tablename
( name1, text2, num7, int8 )
VALUES
( '$data1', '$data2', $data7, $data8 )";

?>

Where $data1 and $data2 are STRING Variables, Text
and $data7 and $data8 are INTEGER values, numbers

For just UPDATE without insert new line use:

<?php

$sql = "UPDATE tablename
SET name1='$data1', text2='$data2', num7=$data7, int8=$data8
WHERE id = $id_num ";

?>

[TheBW]

Is there a chance I cant use array data like this to enter it into table?

$query = "INSERT INTO items
	(playername, itemtype, quality, itemlvl, minwdmg, maxwdmg, ar, statt1, stat1, statt2, stat2)
	VALUES//line 118
	('$playername','$itemtype','$quality','$data['itemlvl']','$data['minwdmg']','$data['maxwdmg']','$data['statAR']','$data['statt1']','$data['stat1']', '$data['statt2']', '$data['stat2']')";
	if ($itemtype != 0){
	mysql_query = $query or die(mysql_error());
	}

Because it gives me this error:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\Game\itemgen.php on line 119

[tommyrulez]

You are missing ():

$query = ("INSERT INTO items
    (playername, itemtype, quality, itemlvl, minwdmg, maxwdmg, ar, statt1, stat1, statt2, stat2)
    VALUES//line 118
    ('$playername','$itemtype','$quality','$data['itemlvl']','$data['minwdmg']','$data['maxwdmg']','$data['statAR']','$data['statt1']','$data['stat1']', '$data['statt2']', '$data['stat2']')");
    if ($itemtype != 0){
    mysql_query = $query or die(mysql_error()); 

[TheBW]

tnx, but it still gets the same error. What else could be the cause?

[Pikachu2000]

Echo the query. If you use phpMyAdmin, paste it in to see what's going on, or execute the query from a mysql> command line prompt.

$query = "INSERT INTO items 
    (playername, itemtype, quality, itemlvl, minwdmg, maxwdmg, ar, statt1, stat1, statt2, stat2) 
    VALUES//line 118 
    ('$playername','$itemtype','$quality','$data['itemlvl']','$data['minwdmg']','$data['maxwdmg']','$data['statAR']','$data['statt1']','$data['stat1']', '$data['statt2']', '$data['stat2']')"; 

// Throw in an echo to see what is actually being sent to mysql_query().
echo( $query );

if ($itemtype != 0){ 
mysql_query = $query or die(mysql_error()); 
} 

[TheBW]

Ok, PMA gave me this error from console

#1064 - 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 'itemlvl']','$data['minwdmg']','$data['maxwdmg']','$data['statAR']','$data['statt' at line 4

INSERT INTO items(
playername,
itemtype,
quality,
itemlvl,
minwdmg,
maxwdmg,
ar,
statt1,
stat1,
statt2,
stat2
)
VALUES (
'$playername', '$itemtype', '$quality', '$data['itemlvl ']', '$data['minwdmg ']', '$data['maxwdmg ']', '$data['statAR ']', '$data['statt1 ']', '$data['stat1 ']', '$data['statt2 ']', '$data['stat2 ']'
)

It probably has problems with array data. I'm not sure how to use it or even if I can use it in this case, but myb I should use extract() function?

[Pikachu2000]

TheBW;10945877 wrote:

Ok, PMA gave me this error from console

#1064 - 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 'itemlvl']','$data['minwdmg']','$data['maxwdmg']','$data['statAR']','$data['statt' at line 4

INSERT INTO items(
playername,
itemtype,
quality,
itemlvl,
minwdmg,
maxwdmg,
ar,
statt1,
stat1,
statt2,
stat2
)
VALUES (
'$playername', '$itemtype', '$quality', '$data['itemlvl ']', '$data['minwdmg ']', '$data['maxwdmg ']', '$data['statAR ']', '$data['statt1 ']', '$data['stat1 ']', '$data['statt2 ']', '$data['stat2 ']'
)

It probably has problems with array data. I'm not sure how to use it or even if I can use it in this case, but myb I should use extract() function?

I believe you need to properly use the quotes in the query string. That looks way off to me. I do it this way:

$query = "INSERT INTO table 
( data1, data2, data3) 
VALUES 
( '" . $var1 . "', '" . $array2['index2'] . "', '" . $var3 . "' )";