Jump to content

Archived

This topic is now archived and is closed to further replies.

laiseng

mysqli_sql_exception 'No index used in query/prepared statement

Recommended Posts

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'No index used in query/prepared statement SELECT * FROM members' in /var/www/html/myfyp/db/members.class.php:141 Stack trace: #0 /var/www/html/myfyp/db/members.class.php(141): mysqli->query('SELECT * FROM m...') #1 /var/www/html/myfyp/login.php(13): members->login('admin', 'admin') #2 {main} thrown in /var/www/html/myfyp/db/members.class.php on line 141[/quote]

i have the error when trying to execute a sql statement within my php code

how do i fix this?

Share this post


Link to post
Share on other sites
I haven't used mysqli much, but from what I've read on the net concerning the message it's not really an "error". The message only indicates that the query doesn't use an index.

You might find [a href=\"http://php.net/mysqli_report\" target=\"_blank\"]mysqli_report[/a] useful.

Share this post


Link to post
Share on other sites
[a href=\"http://dev.mysql.com/doc/refman/4.1/en/indexes.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/indexes.html[/a]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.