use of EXPLAIN

--0-44040098-1185519376=:11938
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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?

same message is shown when i search the comment table and display it . query display all comments in comment table

ok bye


Asim Jamil - 0092 345 4025907, Pakistan

---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.
--0-44040098-1185519376=:11938--

Re: use of EXPLAIN

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).

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php