You can't do it through PHP.
';' - won't work
Maxim Maletsky
www.PHPBeginner.com
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
Sent: giovedì 4 ottobre 2001 6.24
To: Maxim Maletsky (PHPBeginner.com)
Cc: 'sc'; [EMAIL PROTECTED]
Subject: Re: RE: [PHP] write to multiple sql tables
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]