Setting Session Variable Help

Hi, I have 2 pages with separate upload forms. The first one has 4 file upload fields and is supposed to set 4 session variables and then the next one has 6 upload fields and 6 session variables. After the second upload page the user is redirected to the cart page with the item they were uploading the files for. I inserted the php strings for the session variables there but they don't show up. The files are uploaded, but the session variables with the server image name are not set. Can you take a look and see what the problem is. I've attached the files below. Once that is working then I have an insert record on the confirm page that should insert the order ID and the server image names into a table. Thanks for the help. The first upload form url is upload_your_pet_photos.php

the code that sets the session variables is before the code that uploads the images.


you need to rearrange the code so that the images are uploaded first, then the sessions can be set.

Oh duh, that was an easy one I missed. I'm trying to use the eCart Store Cart Summary in Database to put the server image file name variables into the database along with the order id, but I'm getting the following error. I've attached the confirm.php page. Thanks

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Photo1],[Photo2],[Photo3],[Photo4],[Photo5],[Photo6],[Photo7],[Photo8],[Photo9]' at line 1

did you name the photo columns in your database using the square brackets?:
[photo1]


this is not a valid column name, the square brackets should not be used in the column name.

No, the names are just Photo1, Photo2, etc. I don't know why the brackets are there. I took them out and everything works except that the order ID is not submitted. Is there a way I can get that to submit into the same table as the photo variables?

in the store order details to store the photo info, you have the order id set as the primary key column, you need to set another column as the key column, then bind the order id column to the OrderID session variable created by the store order summary behavior for the orders table.

I tried that, but the OrderID is still not showing up in the database. Any Idea why? I've attached the php file.

change the trigger of the store order summary behavior for the images to Submit Order button pressed instead of using Any form Post.

Thanks, I figured out I also didn't have the Order ID set right, so it wasn't putting it in the database. thanks for the help.

ok, glad to hear it is working.