[PHP 4, PHP 5]
mysql_query — Send a MySQL query
Description
mysql_query[string $query
, resource $link_identifier
= NULL]:
mixed
Parameters
query
An SQL query
The query string should not end with a semicolon. Data inside the query should be properly escaped.
link_identifier
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[] had been called with no arguments. If no connection is found or established, an
E_WARNING
level error is generated.
Return Values
For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query[] returns a resource on success, or false
on error.
For other type of SQL statements, INSERT, 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.
Examples
Example #1 Invalid Query
The following query is syntactically invalid, so mysql_query[] fails and returns false
.
Example #2 Valid Query
The following query is valid, so mysql_query[] returns a resource.