syntax again

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());

laserlight

The username is likely to be a string, but you did not delimit it with single quotes in your SQL statement $get.

182x

$username isn't part of the array and sorry for the newbie question but what do you mean by delimited?

I thought it would be an issue with the row array.

laserlight

$username isn't part of the array

That's correct. Let's change the code a little:

$get = "SELECT * FROM user WHERE username = $username";
$query = mysql_query($get, $link_id)or die("Could not select user: " . 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("Could not insert: " . mysql_error());

Are you able to identify which SQL statement caused the error now?

what do you mean by delimited

Enclosed, separated, etc. Basically, some symbol that denotes the start and/or end of a token.

182x

Thanks, I tried to delimit it by using braces, but this is also wrong. Is there any other methods of delimitation I can use?

laserlight

Single quotes. This is SQL, not PHP (though PHP uses single quotes to delimit strings as well).

$get = "SELECT * FROM user WHERE username = '$username'";

NogDog

The first problem is that you need to quote your string literals in SQL just as you do in PHP:

$get = "SELECT * FROM user WHERE username = '$username'";

While $username is a variable in your PHP script, when the query string gets sent to MySQL the variable's value will be provided, not the PHP variable (which MySQL knows nothing about), so it will just be a character string when the SQL is parsed, and thus must be quoted so that it is not treated as a column name.

182x

Thanks, with the same code I now get the following error:

I was also wondering, in my other scripts I did not delimit the variable part of the query (I am going to though) but they still managed to work fine is that normal?

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\xampp\htdocs\a\test.php on line 38

maxpup979

strings must be delimited with ticks in sql, however numbers are not. So if your other queries only involve numbers in the where clause, that is likely why.

As for the error message, post the code, and we can track it down.

182x

$get = "SELECT * FROM user WHERE username = '$username'";
$query = mysql_query($get, $link_id)or die("Could not select user: " . 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("Could not insert: " . mysql_error());

maxpup979

Heh--which line is line 38?

182x

sorry about that line 39 is as follows:


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

maxpup979

I am not seeing any issues with the code you have posted (granted, I could be missing something)--
The error you are getting is usually associated with a missed quote, or bracket of some kind. Check back through the rest of your code and see if that might be the issue.