[SOLVED] variable unexpectedly becomes undefined...

[TheLostGuru]

Ok, I have pin pointed the problem down to the exact line, but I don't understand why it is happening.

I have a variable called $_oid which contains the value "Kesler".

 

echo "&name=$_oid";
$query = "INSERT INTO users (vid, age, sex, country, photo, name, userID) values ('$_vid', '$_age', '$_sex', '$_country', '$_photo', '$_name', '$_userID')";
mysql_query{$query} or die(mysql_error());

 

Now with that code right now, &name comes out as undefined.  However if I remove the mysql_query part (see below), &name comes out as "Kesler". 

 

echo "&name=$_oid";
$query = "INSERT INTO users (vid, age, sex, country, photo, name, userID) values ('$_vid', '$_age', '$_sex', '$_country', '$_photo', '$_name', '$_userID')";
//mysql_query{$query} or die(mysql_error());

 

Any ideas?  Is there something wrong with my query?

[chigley]

&name isn't defined as a variable name, it is just echod?

[TheLostGuru]

correct.  echo "&name=$_oid";  Worked just fine until I hit into this query.

[trq]

Where is $_oid defined?

[TheLostGuru]

It is retrieved using $_POST.  I know that the variable is good.  It's value is set.  It just has something to do with this query because I have tested it.  I've gone through my code testing when the echo code sends the correct value of the variable, and it makes the switch over to undefined at this query. 

[kenrbnsn]

You have curly brackets in this statement:

<?php
mysql_query{$query} or die(mysql_error());
?>

they should be parenthesis:

<?php
mysql_query($query) or die(mysql_error());
?>

 

Ken

[TheLostGuru]

Ken - Super Thanks!  I knew it had to be something really silly like that.  Thanks for the sharp eyes.