MySQL SELECT from PHP

I have one table ( members ) and five columns ( username , passw开发者_StackOverflow社区ord , FirstName , LastName , Email )

I need to get the Email for the user admin. How would this be done?

---

SELECT Email FROM members WHERE username = 'admin';

---

Do you know what the username is of the admin? If so you can do the following:

SELECT `Email`
FROM `members`
WHERE `username` = {$username}