Question concerning $_GET and URL's

buyocat

Alright, let me outline my problem then I'll show some code. The problem is I have a value in the URL that I can retrieve, and echo correctly, with the $GET function. I will store this value into a variable then query the SQL database to insert the value, along with several others, into the database. Now, when I run the whole thing everything works correctly, the variable echo's the right thing all the data is submitted and entered into the database with the exception of one thing; the variable that I defined with $GET isn't going into the database, instead the database is treating it as empty. So, that is the problem the value seems to be disappearing or something can someone help me out? Now for the code...

URL = blah blah/reply.php?post_id=2
... session checked other variables declared
variable is defined
$replyto = $_GET['post_id'];
... page title and header loaded
variable is echo'd
echo"$replyto";
... Submit button activated things are checked out
$query = "INSERT INTO posts (user_id, post_id, post_title, post_body, post_date) VALUES ('$id', '$replyto', '$title', '$body', NOW())";

LoganK

Why not try "echo $query" to see what exactly MySQL is getting?

dfr574

What kind of data field is post_id?
Can you describe table and post the output?

lozza1978

When you submit the data, The page your using for error/validation checking has no $_GET in the URL and thats why its empty, or is the page posting to itself ?

i would do something like this,

<? 
if(isset($_GET['post_id'] )) {
echo $_SERVER['PHP_SELF'], $_GET['post_id'];
}
?>

this way $_GET will allways be in the URL,

I hope this helps you.

lozza