TheLostGuru Posted June 12, 2007 Share Posted June 12, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/ Share on other sites More sharing options...
chigley Posted June 12, 2007 Share Posted June 12, 2007 &name isn't defined as a variable name, it is just echod? Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273300 Share on other sites More sharing options...
TheLostGuru Posted June 12, 2007 Author Share Posted June 12, 2007 correct. echo "&name=$_oid"; Worked just fine until I hit into this query. Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273317 Share on other sites More sharing options...
trq Posted June 12, 2007 Share Posted June 12, 2007 Where is $_oid defined? Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273324 Share on other sites More sharing options...
TheLostGuru Posted June 12, 2007 Author Share Posted June 12, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273335 Share on other sites More sharing options...
kenrbnsn Posted June 12, 2007 Share Posted June 12, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273359 Share on other sites More sharing options...
TheLostGuru Posted June 12, 2007 Author Share Posted June 12, 2007 Ken - Super Thanks! I knew it had to be something really silly like that. Thanks for the sharp eyes. Quote Link to comment https://forums.phpfreaks.com/topic/55292-solved-variable-unexpectedly-becomes-undefined/#findComment-273382 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.