Jump to content


Photo

mysqli_sql_exception 'No index used in query/prepared statement


  • Please log in to reply
3 replies to this topic

#1 laiseng

laiseng
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 10 June 2006 - 11:18 PM

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


#2 shoz

shoz
  • Staff Alumni
  • Advanced Member
  • 600 posts

Posted 10 June 2006 - 11:47 PM

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.

#3 laiseng

laiseng
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 11 June 2006 - 12:37 AM

what does it mean by index?

#4 shoz

shoz
  • Staff Alumni
  • Advanced Member
  • 600 posts

Posted 11 June 2006 - 12:51 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users