I have a site that requires users to enter details about activities they have to offer.
I have two tables.
Table 1 has all the contact details and is reasonably static (option for site administrator to alter details only). Each contact has is defined by the Primary key ID
Table 2 has all the details of the contact and what activities they have to offer. This is editable and added by the contact and has its own primary key and has a feild that relates to the Primary Key on table 1.
I am using the Primary Key to define the link between the two tables so when the user selects from the dynamic selection list on the first page this will search out the correct contact detail and also display a list of activities entered by the contact. The amount of activities can vary for each contact so it is important that the contact can edit and add data at any time.
On the Profile Page that has the contact details and the activities I have an Add button. The Add button links to an input page. This adds all the activities information to Table 2. and I would like it to redirect to a “Thank You” page which an option to add more details are view their profile on the profile page.
Currently it all works with the exertion of the “Thank You” page and the options.
When I sent the details to the table it redirects to the TY page but I can’t get a value to be echoed from the previous input page on the TY page. So this is preventing me from posting the correct information to either the input page or the profile page.
Hope you can help. Code below:
Input page submit:
////php connection
////mysql insert query
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
//////Input feilds
<input type="hidden" name="MM_insert" value="form1">
</form>
Thank you page:
////php connection
<body>
Thank you<br>
Please View Your Details <?php echo $ID; ?> <form action="profile.php" value"form1">
/////// text box added to echo the value being posted//////
<input type="text" value="<?php echo $row_Recordset1['ID']; ?>">
<input type="submit" value="Click Here">
</form>
</body>
So am I right in thinking that all I need is to be able to do is to pass what ever value is in the ID field over to the TY page. Although if I manually type the ID in the text box It doesn’t display any details on the profile page
