Some databsaes allows batches of sql statements. Thes can be passed to the db server in one query and the statements are usally separated by ;
If you are executing a batch of statements each returning a result you will have to process each result in your code. This is supported by ODBC, MS SQL and FrontBase (that I know of) If you want to insert/update data in multiple tables you might also want to choose a database with support for transactions, as this will ensure the consistancy of your data. - Frank > > PHP can only handle a query at a time. If the database in question > allows you to construct a such query where you can write to multiple > files then you can. Go to the manual of your DB and look for the answer > there. For instance; look at the syntax of INSERT. > > Maxim Maletsky > www.PHPBeginner.com > > > -----Original Message----- > From: sc [mailto:[EMAIL PROTECTED]] > Sent: giovedì 4 ottobre 2001 2.17 > To: [EMAIL PROTECTED] > Subject: [PHP] write to multiple sql tables > > > Hi; > > Is there any easy way of writing to multiple mysql tables in the one > database? ie. putting it all in the one query etc? instead of writing a > heap of code... > > Any help would be great... > > thx. > > -sc > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] To > contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
