Multiple query execution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi guys:

I need to execute two insert/update queries within a single statement string
from a PHP
application, but it keeps giving me an error.

For example, I have a listbox which has to insert or update two tables
whithin the same submit action:

INSERT INTO tbl_ISperson(NamePerson, Country) VALUES('John Smith',
'{var_country}');
INSERT INTO tbl_pais_src(name_country) VALUES('{var_country}');
/*Where {var_country}is a variable which stores the value of a country*/

I have found this page
(http://dev.mysql.com/doc/mysql/en/c-api-multiple-queries.html), but I don´t
know how to implement it:

"From version 4.1, MySQL supports the execution of multiple statements
specified in a single query string. To use this capability with a given
connection, you must specify the CLIENT_MULTI_STATEMENTS option in the flags
parameter of mysql_real_connect() when opening the connection. You can also
set this for an existing connection by calling MySQL Reference Manual ::
23.2.9 C API Handling of Multiple Query Execution mysql_set_server_option
MYSQL_OPTION_MULTI_STATEMENTS_ON) By default, mysql_query() and
mysql_real_query() return only the first query status and the subsequent
queries status can be processed using mysql_more_results() and
mysql_next_result()"

Does anybody has tried it in php?. Does anyone could share an example?

Thanks in advance and best regards.

Alvaro.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux