laiseng Posted June 10, 2006 Share Posted June 10, 2006 [!--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 codehow do i fix this? Quote Link to comment Share on other sites More sharing options...
shoz Posted June 10, 2006 Share Posted June 10, 2006 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. Quote Link to comment Share on other sites More sharing options...
laiseng Posted June 11, 2006 Author Share Posted June 11, 2006 what does it mean by index? Quote Link to comment Share on other sites More sharing options...
shoz Posted June 11, 2006 Share Posted June 11, 2006 [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] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.