I seem to have gotten myself a little bit confused in what I'm trying to write.
I'm building an admin area for my website & here is what i have.
I have 1 database with two tables. The first table has category, subcategory, and catid as the fields.
The other table has several fields, for example: id, thumb, screen, text, gallery_id.
I have 4 pages in my admin area, a add, list, delete, and edit page. The list page has links on it to delete and edit entries. Naturally, when you click edit it refers to the ID # of the entry.
The problem is when I click the link to go to the edit page it only shows 1 category in the drop down box. I want it to show them all. I want the form to pull all the correct settings for whatever id # it is, but i also want it to list all the Categories and Subcategories.
I hope i explained that well enough...so confused.