Help me with this query

[mokujin]

hello,

I have this SQL

PHP Code:

$buddys = $db->query_read("
        SELECT user.username, user.userid
        FROM " . TABLE_PREFIX . "userlist AS userlist
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = userlist.relationid)
        WHERE userlist.userid = {$vbulletin->userinfo['userid']} AND userlist.relationid = user.userid AND type = 'buddy'
    "); 


Now how do I get all userid to one line like this: $buddyids = "1,9,67,89,102" ???

I want to use $buddyids to work with another query

Please help me

Thank you

--------------- Added [DATE]1272139718[/DATE] at [TIME]1272139718[/TIME] ---------------

No one can help me? Thank s

[mokujin]

up. please help

[Vaupell]

i would create an array or do a while loop instead using
something like

PHP Code:

$currentid = $vbulletin->userinfo['userid'];
$myfriends = "";
$Buddylist=("SELECT * FROM ".TABLE_PREFIX." WHERE userid='".$currentid."'");
 while($row=$vbulletin->db->fetch_array($Buddylist))
{
$myfriends .= $row['relationid'] .',';
} 


and output would be of $myfriends something like

1,2,24,2,434,2, etc..

then i could always explode the contents if i needed them seperatly..
But you could also pull the individual user info of all the friends inside the loop,
after you got the $myfriends simple create another while loop inside
and fetch content from each user there, and store im in $myfriends[] array.