Creating "multi" views

[osbornej76]

Ok. I'm sure that this has been covered in a previous topic, however I am not even sure what keywords to search on!

Let me explain. I am looking to build a simple activity tracker app using MySQL with a PHP/HTML front end. I have a very basic grasp of SQL and a basic grasp of PHP.

Without boring you with yet another database structure dump.. imagine that I only have 2 related tables Contacts and Activities. A Contact can have many Activities (phone calls etc)

On the Contact's 'form' I want to display an Access style spreadsheet view that displays the Activities (from the Activities table) for that Contact. I would also want the ability to add a new record in the Activities table from that 'spreadsheet'

I understand how to use SQL Join to display the data back in a table, however it seems that I am limited to a 'read only' table.

Apologies for the fluffy post... Any thoughts would be greatly appreciated.

Jim

[DeltaRho2K]

Not at all... In fact, what you are wanting to do is fundamental php/mySQL(ing)...

The reason it's not "read-Only" is because you have now searched both tables to retrieve the data, so as long as each table has a unique key value, then you will not have any problems manipulating the data.

Go to php.net and download the manual, and then go to mySQL.com and download that manual...

Use the mySQL manul to start gaining knowledge about how to retrieve data from databases, and display it. Then you can look through there to start learning how to INSERT, UPDATE and DELETE records...

Starting getting some code into place, and come on back and post it so we can help you tweak it. If you want a pre-written script, try hotscripts.com. They may not have the exact script you want, but there are enough examples out there, that you can adapt one to suit your nee