HELP! with sessions and passing variables

[wmabear54]

Hi

I am building a database using four tables. The first is for sites, the second is for categories, the third is for subcategories and the fourth is for products.

I will be using id numbers to link the tables together with each other primary, master_id, cat_id and subcat_id. It is with the id's that I will seperate all the parts to keep them organized using where clauses like master_id=?, cat_id=? and subcat_id=?
Here is a sample of the tables
and here is a sample of the forms that I will be using.
Feel free to add to it and get a feel for it.

All is working good to add sites, add categories and when I get to subcategories the variables are not passing correctly and the cat_id field is empty.

I am using session_start to keep it together so the id's will be added as I go. What could it be that the variables are not passing.

Thanks in advance
Mike

[php~pro]

Without seeing code its like a pin the tail on the donkey game. Dependant on the information you are trying to pass try echoing the sessions with the info you are trying to input to ensure they have value. Also you say you are using session_start. Is this at the top of your scripts. It must be output as session_start();
Check also your column lengths in tables to ensure thay are the correct size, but the echo should reveal all. If the session is empty just go through code to find out why.

[wmabear54]

Thanks php~pro I took a step back and slowly went through the code copying steps that I knew worked and it finally worked. There are still bugs in it but that is for another day. Known bugs are in the where clauses categories are seperate by site, but subcategories aren't seperated by category yet but I am sure that shouldn't be too hard to figure out. Also I need to auto fill a path to image and I need a path to auto load in an upload script for images.

But thanks check it out if you have a chance
Mike

[wmabear54]

What happen to our edit button. Need to fix the delete link also.
Mike