How to select data from a row in a MySQL database

Question

What I'm trying to do is select data from a specific row only in a MySQL database with PHP. For example, lets say if USER1 is logged in, I want to grab that users data from the row in the database and display it on USER1's profile with PHP. How can I do this with PHP? Please help me as I'm new to MySQL!

You'll get more help if you can show that you have tried to do something for yourself. — Ben
– Ben, Commented May 6, 2012 at 16:08

Darren Burgess · Accepted Answer · 2012-05-06 16:27:15Z

1

This should work for what you need.

$result = mysql_query("SELECT * FROM Persons WHERE user ='$user1'");

while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
  }

answered May 6, 2012 at 16:27

Darren Burgess

4,3426 gold badges29 silver badges43 bronze badges

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

Comments

reza ostadi · Accepted Answer · 2012-05-06 16:13:41Z

0

look this tutorials:

http://www.homeandlearn.co.uk/php/php13p2.html

http://php.about.com/od/phpwithmysql/ss/mysql_php_2.htm

answered May 6, 2012 at 16:13

reza ostadi

3072 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to select data from a row in a MySQL database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related