SQL Syntax and Columns using PHP

Question

(This is called via PHP) I have the following:

"SELECT name FROM user WHERE uid IN (SELECT uid1 FROM friend WHERE uid2={$user})"

The SQL executes perfectly fine, however, the result is an array where the key is "name". I would like each result's key to be the respective uid in user that was searched to pull that name.

Example:

How it is right now

If the name was "Bob" and his uid was "12345", I would like the return array to be - [name] => Bob.

How I would like it to be

If the name was "Bob" and his uid was "12345", I would like the return array to be - [12345] => Bob.

EDIT (as per the comment request):

$fql = "SELECT pic FROM user WHERE uid IN (SELECT uid1 FROM friend WHERE uid2={$user})";
        $param = array(
            'method' => 'fql.query',
            'query' => $fql,
            'callback' => ''
        );
$result = $facebook->api($param);

Show us some code. How are you executing the query? What does this have to do with Facebook? — kba
– kba, Commented May 13, 2012 at 0:39

kba · Accepted Answer · 2012-05-13 00:43:21Z

2

$newResult = array();
foreach ($result as $entry)
{
    $newResult[$entry['uid']] = $entry['name'];
}

answered May 13, 2012 at 0:43

kba

19.5k6 gold badges65 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

SQL Syntax and Columns using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related