I'm fairly new to php so please forgive me if this was answered somewhere else. I wanted to create a master/detail list for records I'm pulling up using tim uckun's odbc socket server script. I added insert,update,delete, and html forms to his script and got it all working. What i wanted to do next was create a master-detail but i don't have a clear understanding of how i would go about this. Is there a good tutorial that explains the concept and coding? I googled for the master/detail php tutorial but only turned up some german sites and phakt, an add-in for dreamweaver mx. I downloaded this and created a working master/detail script but have trouble deciphering their functions. (let me know if you want to take a look at the phakt code if it would help).
-using php4,access,w2k, odbc socket server, iis5,
- I was thinking that you could write out php code in the html tags when you print out the query so you could call another php page or do this with a form. But what boggles me is that i would need two queries, one for master and one for detail and when the user selects i would need a generic variable to be passed on
to the details page. would i have to use an array and a count variable ( array gen_variable[0]) to keep track? or to pass on ?record_id=&?
master page:
username //printed query from db of 500 users
detail page:
first name
lastname
email...etc
in the details page, i should be able to use the same technique in the master to click on any of the fields and pass the varialbe to update-- with my update script.?
Any help would be greatly appreciated! THank you.
-tribe
tim's odbc socket server tutorial url below
