ID: 35450 Updated by: [EMAIL PROTECTED] Reported By: jellicle at gmail dot com -Status: Open +Status: Bogus Bug Type: MySQLi related Operating System: Debian PHP Version: 5.1.0 New Comment:
Use mysqli_report() to disable that. Previous Comments: ------------------------------------------------------------------------ [2005-11-28 16:35:26] jellicle at gmail dot com Description: ------------ Mysqli extension throws too many warnings. For example, "SELECT * FROM table" results in a warning: "Warning: mysqli::query(): No index used in query/prepared statement SELECT * FROM table ..." There's no way to have MySQL use an index when selecting all records, so this warning appears every time one wants to select all records from any table. Sometimes Mysqli gives this warning even when MySQL is apparently using an index (i.e. the same query, executed with EXPLAIN, says it's using an index). Mysqli should give warnings only on real problems. Not using an index is at most worthy of a notice, not a warning, especially when there's no way to use an index with a particular query! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35450&edit=1
