ansaurus

Question

MySQL SELECT from PHP

Answer 1

+1 A:

SELECT Email FROM members WHERE username = 'admin';

Zurahn 2010-09-24 22:00:36

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

Zachary Brown 2010-09-24 23:55:19

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: http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html

Zurahn 2010-09-25 05:01:06

Answer 2

A:

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

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

Aaron Hathaway 2010-09-24 22:01:34

ansaurus

tags:

views:

answers:

MySQL SELECT from PHP

related questions