How do you join (implode) a MySQL Array?

Question

The implode() function works on normal arrays, but it doesn't work on arrays created with mysql_fetch_array (I also tried mysql_fetch_row)

How do you get them to work?

Defined Above:

$friends = mysql_query("SELECT * FROM friend

WHERE u1='$userinfo[username]' OR u2='$userinfo[username]' ");

And further down:

$friendsrow = mysql_fetch_array($friends);
$friendsrow = join(",",$friendsrow);

$friendnotes = mysql_query("SELECT nid,user,subject,message FROM friendnote WHERE user IN ($friendsrow) ORDER BY timestamp ASC LIMIT 0,5");

(In case your wondering, that is for a community site)

Bill Ortell · Accepted Answer · 2011-09-26 16:09:08Z

3

Wouldn't GROUP Concat work?

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

answered Sep 26, 2011 at 16:09

Bill Ortell

8378 silver badges12 bronze badges

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

Comments

Eimantas · Accepted Answer · 2010-01-16 12:17:59Z

1

You can always use sub-select and pass it to IN() operator.

answered Jan 16, 2010 at 12:17

Eimantas

49.5k17 gold badges135 silver badges173 bronze badges

Comments

Tor Valamo · Accepted Answer · 2010-01-16 14:46:18Z

1

I think you're joining the wrong thing. You're joining the entire friend ROW, so the result is '1,Johnny,23years,etc'. I'm assuming you want a list of the friend ID's '1,2,3,4,5'. As Eimantas said it's better to use a subquery.

SELECT nid,user,subject,message 
FROM friendnote 
WHERE user IN ((SELECT u2 FROM friends WHERE u1 = $userinfo[username])
               UNION
               (SELECT u1 FROM friends WHERE u2 = $userinfo[username]))
ORDER BY timestamp ASC LIMIT 0,5

edited Jan 16, 2010 at 14:46

answered Jan 16, 2010 at 12:22

Tor Valamo

33.9k11 gold badges76 silver badges82 bronze badges

1 Comment

Ryan Over a year ago

Thanks, the errors disappear but the actual script doesn't seem to do anything =( I used: $friendnotes = mysql_query("SELECT nid,user,subject,message FROM friendnote WHERE user IN ('SELECT u1,u2 FROM friends WHERE u1 = $userinfo[username] OR u2 = $userinfo[username]') ORDER BY timestamp ASC LIMIT 0,5"); When I try to use a MySQL function such as mysql_fetch_array() it doesn't return an error, but doesn't return any results either (and yeah I know theres entries in the database that matches the WHERE)

Daniel Dinu · Accepted Answer · 2010-01-16 12:27:09Z

0

mysql_fetch_array returns normal arrays, there is nothing special about them. Maybe your query isn't returning anything, and in that case mysql_fetch_array returns false. Check for that before trying to implode the result.

edited Jan 16, 2010 at 12:27

answered Jan 16, 2010 at 12:19

Daniel Dinu

1,76612 silver badges16 bronze badges

Collectives™ on Stack Overflow

How do you join (implode) a MySQL Array?

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related