I need a form to tie MySQL Records together.
- by John R
I need a HTML-based form to tie database records together. The user scenario that I envision is somthing like this:
A super-user does a search of the database and is delivered a table of records based on that search; each record is numbered with the database-record id.
There would also be two text fields next to each record. These text fields would allow:
the user to make a reference from one record to another. For example, a user could enter into record id #457 the integer 242 to indicate that there is a correlation with record ID #242.
The user would also describe the type of relationship it is. This could be accomplished with a simple integer in the second field that indicates the type of relationship between the two records.
When the super-user hits the submit button, all of these relationships are saved in a mySqljoin table.
One option is to give me advice on how to implement and code this myself in PHP. However, before I reinvent the wheel, another option is to lead me to a free script that does something similar.