PHP/MySQL - Get multiple fields from one entry in a table

Question

I thought I could find loads of examples on how to do this but nothing I find tells me how to get the values in PHP.

Say I have this code:

$query = "SELECT name, age FROM people WHERE id = 2";
$result = mysql_query($query);

How do I get the data from $result?

Pseudo code:

$name = $result['name'];
$age = $result['age'];

Have a look at mysql_fetch_array and have a look at the red box. Please consider using mysqli or PDO right from the start. — VMai
– VMai, Commented Aug 9, 2014 at 14:59

Santiag00 · Accepted Answer · 2014-08-09 15:00:27Z

1

Did you try this?

$query = "SELECT name, age FROM people WHERE id = 2";    
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo $row['name'];
echo $row['age'];

answered Aug 9, 2014 at 15:00

Santiag00

6667 silver badges14 bronze badges

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

1 Comment

user1009573 Over a year ago

Thank you, I will accept this answer when it lets me in 9min.

Robby Cornelissen · Accepted Answer · 2014-08-09 15:00:31Z

1

You need to get a row from the result first. You can get a number-based array using mysql-fetch-row or an associative array using mysql-fetch-assoc.

$query = "SELECT name, age FROM people WHERE id = 2";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

$name = $row['name'];
$age = $row['age'];

To note: the mysql functions are deprecated. You should use mysqli or PDO instead.

answered Aug 9, 2014 at 15:00

Robby Cornelissen

98.6k23 gold badges154 silver badges180 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL - Get multiple fields from one entry in a table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related