I need a form to tie MySQL Records together (i.e., many-to-many relationships).

Posted by John R on Pro Webmasters See other posts from Pro Webmasters or by John R
Published on 2011-03-19T18:09:49Z Indexed on 2011/03/20 0:17 UTC
Read the original article Hit count: 177

Filed under:
|
|
|

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:

  1. the user to make a reference from one record to another. For example, a user could enter into record id #457 that there is a correlation with record ID #242.
  2. The user would also describe the type of relationship it is. This could be with a simple integer that represents 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.

© Pro Webmasters or respective owner

Related posts about php

Related posts about mysql