PHP Nubsauce Posted July 7, 2008 Share Posted July 7, 2008 Can anybody tell me why my slideshowid isent pushing through right? It's sitting in the actual URL just fine. $query = "INSERT INTO slideshow_images (max_image_name, max_image_size, max_image_type, max_image_content, request_id, side_caption, photo_caption, for_sale, approved, slideshow_id) ". "VALUES ('$thumbfileName', '$thumbfileSize', '$thumbfileType', '$thumbcontent', '$_POST[requestid]', '$_POST[sidecaption]', '$_POST[photocaption]', '$_POST[forsale]', 'no', '$_GET[slideshowid]')"; Any help would make me jump with joy. Thanks, Nubsauce. Quote Link to comment Share on other sites More sharing options...
lemmin Posted July 7, 2008 Share Posted July 7, 2008 Try this for the values part: "VALUES ('$thumbfileName', '$thumbfileSize', '$thumbfileType', '$thumbcontent', '$_POST[requestid]', '$_POST[sidecaption]', '".$_POST[photocaption]."', '$_POST[forsale]', 'no', '$_GET[slideshowid]')"; Quote Link to comment Share on other sites More sharing options...
PHP Nubsauce Posted July 7, 2008 Author Share Posted July 7, 2008 No this did not work, but thanks for trying ! php nubsauce Quote Link to comment Share on other sites More sharing options...
craygo Posted July 7, 2008 Share Posted July 7, 2008 you need to come out of your quotes when you want to insert $_POST and $_GET values directly. Or put them in brackets you should also use single quotes for the post and get values. I put the values on seperate line to make sure the count was correct, you can return it to normal $query = "INSERT INTO slideshow_images (max_image_name, max_image_size, max_image_type, max_image_content, request_id, side_caption, photo_caption, for_sale, approved, slideshow_id) ". "VALUES ('$thumbfileName', '$thumbfileSize', '$thumbfileType', '$thumbcontent', '".$_POST['requestid']."', '".$_POST['sidecaption']."', '".$_POST['photocaption']."', '".$_POST['forsale']."', 'no', '".$_GET['slideshowid']."')"; Ray Quote Link to comment Share on other sites More sharing options...
PHP Nubsauce Posted July 7, 2008 Author Share Posted July 7, 2008 This is now fixed! Thanks all! Quote Link to comment Share on other sites More sharing options...
lemmin Posted July 7, 2008 Share Posted July 7, 2008 Woops, I only saw one occurance of that, for some reason. Thanks, craygo, that is what I was trying to get across. Quote Link to comment Share on other sites More sharing options...
PHP Nubsauce Posted July 7, 2008 Author Share Posted July 7, 2008 i figured that lemmin, as ray was posting, i was doing what u told me to do on the one of them to all of them Quote Link to comment 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.