syntax error

[182x]

hey guys I keep getting the following error with the following code where temp is an actual value, I know it has something to do with the $row syntax just wondering if you can point out what I did wrong? Thanks

 

error: Unknown column 'temp' in 'where clause'

$get = "SELECT * FROM user WHERE username = $username";
$query = mysql_query($get, $link_id)or die(mysql_error());
$row = mysql_fetch_array($query);



$hold="INSERT INTO supp VALUES('','{$row['level']}','$username','{$row['name']}','{$row['carrN']}','{$row['mIp']}','$da', '$daT', 'thank you', 'hU')";
mysql_query($hold, $link_id)or die(mysql_error());

 

[play_]

need to escape string inside the query.

like here: $hold="INSERT INTO supp VALUES('','{$row['level']}','.....

[182x]

If I add that I then get the following errror:

 

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING

[AndyB]

in your originally posted code, change

 

mysql_query($hold, $link_id)or die(mysql_error());

 

to

 

mysql_query($hold, $link_id)or die("Error: ". mysql_error(). " with query ". $hold);

 

That will display the actual query string and then you'll be on the way to fixing the problem.