how to return many values in mysql_fetch_array php

Question

I want to get the first_name and the last_name from a database.
I select them, but then I'm unable to return both with a space in-between them, and need it to be returned not echoed because I am going to use it as a link for the user profile.

function getuser ($id, $field_one, $field_two) {
$query = mysql_query("SELECT $field_one, $field_two FROM users WHERE user_id='$id'");
$run = mysql_fetch_array($query);
return $run[$field_one, $field_two];

}

I think the problem is in the last 2 lines

$run = mysql_fetch_array($query);
return $run[$field_one];

AliBZ · Accepted Answer · 2013-08-15 22:55:46Z

2

Try this:

return $run[$field_one] . " " . $run[$field_two];

BTW you have to change your query to:

"SELECT {$field_one}, {$field_two} FROM users WHERE user_id={$id}"

Take a look at this for examples: http://php.net/manual/en/function.mysql-fetch-array.php

answered Aug 15, 2013 at 22:55

AliBZ

4,09912 gold badges48 silver badges68 bronze badges

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

Comments

Langdi · Accepted Answer · 2013-08-16 00:08:57Z

0

If you always need the full name you might use something like SELECT CONCAT(firstname, " ", lastname) as fullname FROM table already in your SQL.

answered Aug 16, 2013 at 0:08

Langdi

2291 silver badge10 bronze badges

Collectives™ on Stack Overflow

how to return many values in mysql_fetch_array php

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