DB management form tutorial for multiple input types?

[dmacster]

I've been looking for some time this morning, but can only find tutorials on basic insert into a mysql db for one table and with text fields.

I've a mysql db with 3 tables. Users (for the login to manage), categories (has 15 cats in 2 fields - structure of cat id and cat name, and advertisers (has advertiser id, category id, name, img1, img1width, img1height, img1, img2width, img2height and visible.)

I'm looking for a tutorial to figure out how to make a form to administer the db (the people are not comfortable using phpmyadmin).

I need to have a page that shows all the advertiser names with an add advertiser link, and edit and delete links for the listed advertisers.

Add advertiser or edit should show checkboxes for the category name, text fields for most of the info from advertisers table, and a radio button for visible/not visible. The checkboxes on submit should put the correct category id into the advertiser table. I guess really I should use radio buttons for category name so they can't multiple select.

Does anyone know of a tutorial for a simpleton like me to get going with this?

Thanks,
Donna

 

[jpadie]

Donna,
what you're looking for is a CRUD system (create, read, update, delete).
have a look at this thread for some sample CRUD code thread434-1254677

I'm sorry to say that i don't know any tutorials on the subject.

 

[dmacster]

Thanks, jpadie. I'll look at that. I'll do some searches on that also after I've read the thread.

Donna