[SOLVED] Putting sql results into an array

[brooksh]

Not sure what I'm doing wrong, but I just want the results to be $array = "image1,image2,image3";

 

$sql = "SELECT imagename FROM images WHERE id = '$id'";	
         $result = mysql_query($sql);
      while($row = mysql_fetch_array($result))
            {
                        $result_array[] = $row['imagename];
            }
$array = $result_array;

[trq]

"image1,image2,image3";

 

Is a string, not an array.

 

$sql = "SELECT imagename FROM images WHERE id = '$id'";	
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_array($result)) {
      $result_array[] = $row['imagename'];
    }
  }
}
$str = implode(',',$result_array);
echo $str;

[brooksh]

Thanks. That works.