Hidden field problem

7724

Hi Guys,

Quick one on an insert query if I may:

This inserts all the data into Mysql database from data entered into textboxes in a form:

$query = "INSERT INTO cms_pictures(date_uploaded,main_dir,main_name,thumb_dir,thumb_name,pic_credit,pic_caption,pic_ref,story_id) VALUES 
('$date_uploaded','$main_dir','$main_name','$thumb_dir','$thumb_name','$pic_credit','$pic_caption','$pic_ref','$story_id')";
   $msg = "A new picture has been added to the database - Please Click <a href=\"http://index\">Here</a> to return to the main menu";

Apart from story_id which is a hidden field that I ask my page to grab from the top of the page ie:

http://www.mysite.com/pictures/upload.php?story_id=32

INPUT TYPE="hidden" NAME="story_id" VALUE="<?php echo $_GET['story_id'];?>" />

But it does not post the value of story_id into the database?

Any ideas why?

Thanks

Chris

radam

7724,

I would recommend checking the following (if you have not done so already):

1 - Check your form HTML as sent to the browser, and see if the story_id field is actually given a value
2 - Check that the PHP script actually receives story_id
3 - Check that the database does not return any errors. If using mysql try:

echo mysql_error()

If all of those check out, can you post your code on http://textpaste.net (shameless plug) and I will see what I can do.

halojoy

you might have to put a value into $story_id


$story_id = $_GET['story_id'];

$query = "INSERT INTO cms_pictures(date_uploaded,main_dir,main_name,thumb_dir,thumb_name,
pic_credit,pic_caption,pic_ref,story_id) VALUES
('$date_uploaded','$main_dir','$main_name','$thumb_dir','$thumb_name',
'$pic_credit','$pic_caption','$pic_ref','$story_id')";
$msg = "A new picture has been added to the database - Please Click 
<a href=\"http://index\">Here</a> to return to the main menu";