Passing Variables / Sub Form possible?

[azaidi]

I'm fairly new to php and am trying to put together a simple contact mgmt system for my outfit. I'm stuck with the usual passing variables for newbies problem and would really appreciate some help

The application has 2 mysql tables as follows:

Contacts table ( simplified )

id as primary key with auto_increment
name
deptt

Interactions table

interactionid as primary key with auto_increment
id ( from Contacts table for relation )
date
interactiontype

I have a main form in edit.php script which allows for add/update etc. And the way I have laid out the form is that the contacts info is in the center and the related interactions on the left in a <table> which works off a Select statement

Select .. where Interactions.id=$id..

I have tested manually with inserts into the Interactions table but want a simple script addition to display a small window with the appropriate interaction objects, and then do the interaction insert so that it gets displayed on the left. How do I do this so that the displayed contact id gets inserted into the interactions id automatically and also the current date gets inserted into the interactions date field.

I know I'm pushing my luck here ( and space ) but once the interaction is displayed on the left, i'd like to be able to edit it. Is there an easy way to do this

And finally, isn't there a tool in the php/mysql world that allows me to create a simple parent / child form?

Thanks

[NiXXeD]

Well, I'm not quite sure what is being asked, and since there are no replies, I'd assume everyone else is feeling the same. Maybe you could ask the question in a different way?

[MrAlaska]

There seems to be lot of questions being asked here, none of which seem specific.

Basically, to edit existing data in the database you need to pull it out of the database with a sql connection, then pass the variables to populate the form used for editing. After the changes are made by the user, he then submits the form. The form posts back to a PHP page who forms a SQL statement and writes them back in to the database.

If you want to insert a new row in a database but include parent information, you incorporate the same method. Hit the database for the parent information you want, then populate the form with that data to include with the new information being inserted.

There are several methods available to insert the date along with the data.