Re: One database, different forms

Hi, I ask a similar question but did not get a reply. I figured out a way. The only thing I do is use one form and four tables. I build the sql statement on the fly. From the from I have a hidden field that will be passed on to the php script. Based on that variable I select the table. You can see a sample of it on vvmm.net/search.php3 $searchstmt = "select "; switch ($vsearch) { case "z": // this exec only if no choice is selected. $searchStmt .= ""; break; case "c": // Select vvmmdb table. Catalog Choice $searchStmt .= "city.city as destinazione, vvmmdb.days, vvmmdb.periodo, vvmmdb.vitofferta, vvmmdb.curr1 as curr2, vvmmdb.url, vvmmdb.stars, vvmmdb.club, vvmmdb.tcode from vvmmdb,city where "; // blah blah } // Check if destinazione has been entered if ($dest) { switch ($vsearch) { case "z": $searchStmt .= ""; break; case "c": // Select vvmmdb table. Catalog Choice $searchStmt .= "vvmmdb.cityid=$citycode and "; $csearchStmt .= "vvmmdb.contid=$countrycode and "; break; // more case statements } I have a whole script about 800 lines. If you need it I will send it. In fact I sent this script earlier. I finally end it with: $stmt = substr($searchStmt, 0, strlen($searchStmt)-4); $stmt1 = substr($searchStmt1, 0, strlen($searchStmt1)-4); Since I do not know which options the viewer is selecting I use the above to remove the " and" at the end of the statement. It works for me. Adrian On Sun, 13 May 2001, midget2000x wrote: > I am writing a PHP application that will operate on a MySQL database. There > will be 4 types of forms (like catalog request, info request, etc.) calling > the code which writes the data to the database. > > Since the variable names on the forms will equal the MySQL column names (as they > should), I am wondering if there is a way for me to create my SQL statements on > the fly so that only data passed is written. Otherwise I'll have to create 8 > types of SQL statements...INSERT (if the record, keyed by e-mail address, > doesn't exist), and UPDATE (if the record does exist) for all 4 forms. > > For example, on my "add to mailing list" form, only the e-mail address is > collected. I'd like the PHP to recognize that only the 'email' field is passed > and create the SQL statement that only writes the e-mail to the database. > > Any ideas greatly appreciated! > > Thanks, > > Rory > > -- ----------- > providing the finest in midget technology >