Menu
Community /Pin to ProfileBookmark
@NogDogJul 03.2010 — #As stated in [url=http://php.net/mysql_query]the manual[/url] :
What does mysql_query(‘SELECT…’) return?
Does it return an array? An object? I’m clueless.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogJul 03.2010 — #As stated in [B]Return Values[/B]
For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a[B]resource[/B] 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. [/quote]