MySQL SELECT from PHP

Question

I have one table ( members ) and five columns ( username , password , FirstName , LastName , Email )

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

Elle H · Accepted Answer · 2010-09-24 22:00:36Z

1

SELECT Email FROM members WHERE username = 'admin';

answered Sep 24, 2010 at 22:00

Elle H

12.3k7 gold badges43 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Zac Brown Over a year ago

Ok. I think this is working, but how would I display the address on the page?

Elle H Over a year ago

You have to execute the query and assign the result to a variable. There are the mysql_query set of functions, but the best option is to use PDO. This is an excellent resource: phpro.org/tutorials/Introduction-to-PHP-PDO.html

Aaron Hathaway · Accepted Answer · 2010-09-24 22:01:34Z

0

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

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

answered Sep 24, 2010 at 22:01

Aaron Hathaway

4,3832 gold badges21 silver badges17 bronze badges

Collectives™ on Stack Overflow

MySQL SELECT from PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related