Complete PHP MySQL Reference
The mysql_unbuffered_query() function executes a query on a MySQL database.
Unlike mysql_query(), this function does not fetch and buffer the recordset automatically. This saves some memory with large SQL queries, and you can start working on the result set immediately after the first row has been retrieved.
This function returns the query handle for SELECT queries, TRUE/FALSE for other queries, or FALSE on failure.
| Parameter | Description |
|---|---|
| query | Required. Specifies the SQL query to send (should not end with a semicolon) |
| connection | Optional. Specifies the MySQL connection. If not specified, the last connection opened by mysql_connect() or mysql_pconnect() is used. |
Note: The benefits of mysql_unbuffered_query() come at a cost: You cannot use mysql_num_rows() and mysql_data_seek() on a result set returned from mysql_unbuffered_query().
Complete PHP MySQL Reference
| WEB HOSTING |
|---|
| Best Web Hosting |
| PHP MySQL Hosting |
| Best Hosting Coupons |
| UK Reseller Hosting |
| Cloud Hosting |
| Top Web Hosting |
| $7.95/mo SEO Hosting |
| Premium Website Design |
| WEB BUILDING |
|---|
| XML Editor - Free Trial! |
| FREE Website BUILDER |
| Free Website Templates Free CSS Templates |
| Make Your Own Website |
| W3SCHOOLS EXAMS |
|---|
|
Get Certified in: HTML, CSS, JavaScript, XML, PHP, and ASP |
| W3SCHOOLS BOOKS |
|---|
|
New Books: HTML, CSS JavaScript, and Ajax |
| STATISTICS |
|---|
|
Browser Statistics Browser OS Browser Display |
| SHARE THIS PAGE |
|---|