Unable to take query string variable and write to database?

[dilbert]

I have an item id on my query string as follows:

script.php?id=5

I am trying to write that value into my database along with other form values as follows:

$query = "insert into reviews values (null,'".$id."','".$comments."','".$username."','".$location."')";

Everything goes fine except the second column in the database is left blank and the $id is not added?

How can I take the $id variable from the query string and make sure that value passes into the insert statement?

[dalecosp]

For security's sake, many server admins turn "register_globals" to OFF on their PHP installs. AAMOF, it's now that way in the default install.

So, is register_globals ON or OFF for you? It sounds like it's OFF; therefore, do this:

$id=$_GET['id'];
// rest of script here

HTH,

[dilbert]

Actually it was a different error I had🙂 I found it now but I appreciate your help.