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}
精彩评论