Input form to query multiple tables in mySQL database?
criscokid
11:19 pm on Nov 15, 2007 (gmt 0)
Is it possible to code an input form that would query multiple tables in a mySQL database?
phranque
5:18 am on Nov 16, 2007 (gmt 0)
not exactly. the form is active in the client's browser. the db is on the server, so you must have a script on the server that queries the db. the script can be activated by either submitting the form or by using ajax to generate a HTTP GET request upon some triggering action in the form. any script can query multiple tables. your script has to figure out which form elements affect the query and how...