How to retrive a particular record from database in php with mysql?

Am using phpMyAdmin Database.In mysql database having 10 records. The field names are username,password,email,firstname,lastname. But i want to retrive 3 rd record based on username and password. I dont know how to retrive in php with mysql. please give a reply to this post.

Thanks in Advance...