| Re: PS Re: GUI designer in html [message #182463 is a reply to message #182458] |
Mon, 05 August 2013 14:57   |
bill
Messages: 310
Registered: October 2010
Karma:
|
Senior Member |
|
|
On 2013-08-05 12:41 AM, J.O. Aho wrote:
> On 05/08/13 02:59, Norman Peelman wrote:
>> On 08/04/2013 01:09 PM, J.O. Aho wrote:
>
....
>>
>> That's only if you go out of your way to enable multiple statements
>> by using 'mysqli_multi_query()', which doesn't support prepared
>> statements. By default mysqli_query() and mysqli_real_query() do not
>> allow multiple queries separated by semi-colons.
>>
>> http://us2.php.net/manual/en/mysqli.quickstart.multiple-statement.php
>
> Unless something changed, mysqli_query supports multiple statements, but
> the return value do not support to give you the result from all the
> queries, I think it returned the last one.
>
Quite correct and as the manual states;
"
MySQL optionally allows having multiple statements in one statement
string. Sending multiple statements at once reduces client-server round
trips but requires special handling.
Multiple statements or multi queries must be executed with
mysqli_multi_query(). The individual statements of the statement string
are separated by semicolon. Then, all result sets returned by the
executed statements must be fetched.
The MySQL server allows having statements that do return result sets and
statements that do not return result sets in one multiple statement.
"
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]