Forum Moderators: coopster

Message Too Old, No Replies

Input form to query multiple tables in mySQL database?

         

criscokid

11:19 pm on Nov 15, 2007 (gmt 0)

10+ Year Member



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)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



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...