Re: [PHP-DB] use of EXPLAIN

2007-07-27 Thread Chris
Asim wrote: hI when i run script of login check for password and username checking, warning shows that query scans complete table. try to use EXPLAIN statement http://dev.mysql.com/doc/refman/4.1/en/explain.html 'Explain's it pretty well ;) (Yeh a very bad joke :P). -- Postgre

[PHP-DB] use of EXPLAIN

2007-07-26 Thread Asim
hI when i run script of login check for password and username checking, warning shows that query scans complete table. try to use EXPLAIN statement like that what should i do? how to use EXPLAIN statement in php while fetching data from MYSQL?