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.