JavaScript Editor Javascript debugger     Website design 


Send a SQL query to Ingres II (PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres:1.0-1.4.3)
bool ingres_query ( string query [, resource link] )

ingres_query() sends the given query to the Ingres server.

The query becomes part of the currently open transaction. If there is no open transaction, ingres_query() opens a new transaction. To close the transaction, you can either call ingres_commit() to commit the changes made to the database or ingres_rollback() to cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback()). You can also use ingres_autocommit() before opening a new transaction to have every SQL query immediately committed.



A valid SQL query (see the Ingres SQL reference guide).

Some types of SQL queries can't be sent with this function:


The connection link identifier. If not specified, the last opened link is used.

Return Values

Returns TRUE on success or FALSE on failure.


Example 1092. ingres_query() example

($database, $user, $password);

ingres_query("select * from table");
while (
$row = ingres_fetch_row()) {