syntax error

[182x]

Hey guys,

 

Just wondering what is wrong with the following syntax, I was also wondering id there a way to split the insert statement so it can appear over multiple lines?

 

Thanks

 

 

$st=mysql_fetch_array($query2)
$sto="INSERT INTO em VALUES ('','$st['1]','$st['2']','$st['2']','$st['2']','$st['2']','$st['2']','$st['2']','$st['2']')";

 

error: Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\a\t\te.php on line 55

[akitchin]

when incorporating array items into a string to be interpolated, you should generally put curly braces around the array item:

 

$sto="INSERT INTO em VALUES ('','{$st['1']}','{$st['2']}','{$st['2']}','{$st['2']}','{$st['2']}','{$st['2']}','{$st['2']}','{$st['2']}')";

 

you also forgot a closing single quote on $st['1'].

[trq]

Also... numeric indexes should not be surrounded in quotes.

 

$sto="INSERT INTO em VALUES ('','{$st[1]}','{$st[2]}','{$st[2]}','{$st[2]}','{$st[2]}','{$st[2]}','{$st[2]}','{$st[2]}')";