Prototype

bool sasql_multi_query( sasql_conn $conn, string $sql_str )

Description

Prepares and executes one or more SQL queries specified by $sql_str using the supplied connection resource. Each query is separated from the other using semicolons.

The first query result can be retrieved or stored using sasql_use_result or sasql_store_result. sasql_field_count can be used to check if the query returns a result set or not.

All subsequent query results can be processed using sasql_next_result and sasql_use_result/sasql_store_result.

Parameters

$conn   The connection resource returned by a connect function.

$sql_str   One or more SQL statements separated by semicolons.

For more information about SQL statements, see SQL statements.

Returns

TRUE on success or FALSE on failure.

Related functions

• sasql_store_result
• sasql_use_result
• sasql_field_count