fbsql_query

Description

resource fbsql_query ( string query [, resource link_identifier])

fbsql_query() sends a query to the currently active database on the server that's associated with the specified link identifier_ If link_identifier isn't specified, the last opened link is assumed_ If no link is open, the function tries to establish a link as if fbsql_connect() was called with no arguments, and use it_

fbsql_query() returns TRUE (non_zero) or FALSE to indicate whether or not the query succeeded_ A return value of TRUE means that the query was legal and could be executed by the server_ It does not indicate anything about the number of rows affected or returned_ It is perfectly possible for a query to succeed but affect no rows or return no rows_

The following query is syntactically invalid, so fbsql_query() fails and returns FALSE:

Ejemplo 1_ fbsql_query() example <?php $result = fbsql_query ("SELECT * WHERE 1=1") or die ("Invalid query"); ?>

The following query is semantically invalid if my_col is not a column in the table my_tbl, so fbsql_query() fails and returns FALSE:

Ejemplo 2_ fbsql_query() example <?php $result = fbsql_query ("SELECT my_col FROM my_tbl") or die ("Invalid query"); ?>

fbsql_query() will also fail and return FALSE if you don't have permission to access the table(s) referenced by the query_

Assuming the query succeeds, you can call fbsql_num_rows() to find out how many rows were returned for a SELECT statement or fbsql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement_

For SELECT statements, fbsql_query() returns a new result identifier that you can pass to fbsql_result()_ When you are done with the result set, you can free the resources associated with it by calling fbsql_free_result()_ Although, the memory will automatically be freed at the end of the script's execution_

See also: fbsql_affected_rows(), fbsql_db_query(), fbsql_free_result(), fbsql_result(), fbsql_select_db(), and fbsql_connect()_