[RESOLVED] Syntax issue

[182x]

Hey guys, Just wondering where I wenr wrong with the insert syntax as it produces the following error. I was also wondering is there a way to split the insert over multiple lines? Thanks.

Error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\a\tec.php on line 55

$g= "SELECT * FROM em WHERE emd = $pr";
$q= mysql_query($g, $link_id) or die(mysql_error());



$st=mysql_fetch_array($q);
$sto="INSERT INTO empl VALUES ('','$st['emp']','$st['emp']','$st['email']','$st['ph']','$st['pr']','$st['de']','$st['ee']','$st['re']','$st['mre']','$st['mkl']','$st['alp']','$st['repri']','$st['ref']','$st['rw']','$st['ll']','$st['lpl']','$st['uiou']','$st['mk']')";
$res = mysql_query($sto, $link_id)or die(mysql_error());

[laserlight]

You should consider formatting it a bit more nicely:

$g = "SELECT * FROM em WHERE emd = $pr";
$q = mysql_query($g, $link_id) or die(mysql_error());

$st = mysql_fetch_array($q);
$sto = "INSERT INTO empl VALUES
        ('','$st['emp']','$st['emp']','$st['email']',
        '$st['ph']','$st['pr']','$st['de']','$st['ee']',
        '$st['re']','$st['mre']','$st['mkl']','$st['alp']',
        '$st['repri']','$st['ref']','$st['rw']','$st['ll']',
        '$st['lpl']','$st['uiou']','$st['mk']')";
$res = mysql_query($sto, $link_id)or die(mysql_error());

The main problem here is with $sto. The array elements should be properly delimited by braces, e.g.,

$sto = "INSERT INTO empl VALUES
        ('','{$st['emp']}','{$st['emp']}'

[182x]

Thanks are the braces only required due to the array elements being used?

[laserlight]

Yes, in a double quote delimited string.

[182x]

Many thanks, hopefully I will start getting the hang of this soon.