2 replies to this topic

[tonyandpals]

Looking for some PHP help. The extent of my knowledge allows me to connect to a database, read and write data, display data in a table. I need to branch out these skills to perform the following.

I have 3 tables:
Users
Items
ItemsUsed

I need to display a list of all the items in a table (which I can do fine).
I need a check box on each line to indicate whether or not that Item is being used.

If checked, then it writes the userid (from Users) and the itemid (from Items) to the ItemsUsed table.

The user will be logged in, but for this example I guess I could manually pass the userID to the ItemsUsed table as well (since I don't have the login piece setup yet), just to connect the dots.

My problem lies in that I've only ever opened one table at a time, displayed data, or wrote the data. Never a combo of each. So I'm lost at where to go next.

Any coding help or links to good tutorials around this area would be greatly appreciated.

[uncannymanny]

PM me your code and I will sort you out

[tonyandpals]

PMd. Thanks