mysqli_sql_exception 'No index used in query/prepared statement

[laiseng]

[!--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?

[shoz]

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.

[laiseng]

what does it mean by index?

[shoz]

[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]