CODEWITHSUNDEEP
phparraysimplode
elstiv
elstiv

Reputation: 377

Implode array in php mysql_fetch_array

I cannot solve this seeming simple problem. I have the following simple code and all I want is to echo the result of $ATL5_Alert_query and separated by a comma (,): 

$ATL5_Alert_query = mysql_query("SELECT `Mobile` FROM `dbo_tech_name` WHERE `AlertLevel`= 1"); 

$dataset = array();
 while ($data = mysql_fetch_array($ATL5_Alert_query))
 {
   $dataset[] = $data;
 }
echo implode (",", $dataset);

However, I'm getting "Notice: Array to string conversion "...

Upvotes: 0

Views: 2136

Answers (1)

n-dru
n-dru

Reputation: 9430

In your code $data is array as well, so $dataset becomes an array of arrays, which you cannot concatenate. You should get the searched value by this:

while ($data = mysql_fetch_array($ATL5_Alert_query))
{
   $dataset[] = $data['Mobile'];
}

or:

while ($data = mysql_fetch_array($ATL5_Alert_query))
{
   $dataset[] = $data[0];
}

or:

while ($data = mysql_fetch_assoc($ATL5_Alert_query))
{
   $dataset[] = $data['Mobile'];
}

If you however cannot change this, and already have your $dataset array, you can implode it like that:

echo implode(',', array_map(function($a){
  return $a['Mobile'];
},$dataset));

Upvotes: 1

Related Questions