Jump to content

Archived

This topic is now archived and is closed to further replies.

freakness883

Problem using the explode function

Recommended Posts

I have the following code:
[quote]<?php
    $query3 = "SELECT members FROM groups WHERE g_id='".$id."'";
echo "$query3";
    $result3 = mysql_query("SELECT members FROM groups WHERE g_id='1'");
$row = mysql_fetch_row($result3);
    $pieces = explode(" ", $row);
echo $pieces[0];
echo $pieces[1];
if (in_array("bbaker", $pieces)) {
  echo "Got bbaker";
}
else{
  echo "nope";
}
[/quote]

[b]echo "$query3"[/b] is printing out the proper select statement -- runnning the statement manually in MySQL gets me the record "bbaker bbarker". But when I echo [b]$pieces[0][/b] and [b]$pieces[1][/b] I get the output [b]Array[/b] for both. I was hoping for bbaker and bbarker. And also I'm returning false on the condition [b]in_array("bbaker", $pieces)[/b]. Something's wrong with my SQL query. Any help is appreciated.

Share this post


Link to post
Share on other sites
It's because $row itself is an array, and you can't explode an array, only a string.

Share this post


Link to post
Share on other sites
You want to use implode on the $row
[code]<?php echo implode(' ',$row); ?>[/code]
Or you can just use echo on the $row entries:
[code]<?php echo $row[0] . ' ' . $row[1]; ?>[/code]

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.