|
mysql_query() sends a query (to the currently active database on the server that's associated with the specified link_identifier).
A SQL query
The query string should not end with a semicolon.
The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If by chance no connection is found or established, an E_WARNING level warning is generated.
For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_query() returns a resource on success, or FALSE on error.
For other type of SQL statements, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.
The returned result resource should be passed to mysql_fetch_array(), and other functions for dealing with result tables, to access the returned data.
Use mysql_num_rows() to find out how many rows were returned for a SELECT statement or mysql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
mysql_query() will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query.
Example 2. Valid Query The following query is valid, so mysql_query() returns a resource.
|
mysql_connect() |
mysql_error() |
mysql_real_escape_string() |
mysql_result() |
mysql_fetch_assoc() |
mysql_unbuffered_query() |
Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 18:00:08