Untitled

Convert MySQL result to an array strings
$result = mysql_query("SELECT name FROM products");
$names=array();
while ($row = mysql_fetch_row($result)) $names[]=$row[0];
mysql_free_result($result);

function dbGgetCol($sql) {
    $ret = array();
    $res = mysql_query($sql) or trigger_error(mysql_error()." in ".$sql);
    if ($res) {
      while ($row = mysql_fetch_row($result)) {
        $ret[] = $row[0];
      }
      mysql_free_result($res);
    }
    return $ret;
  }

$names = dbGetCol("SELECT name FROM products");

$result = mysql_query("

SELECT `productname` FROM `products`

")or die($result."<br/><br/>".mysql_error());

    $numrows  = mysql_num_rows($result);

    while ($row = mysql_fetch_assoc($result))
    {

    $productname[$i] = $row['productname'];

            // to print out use the following
             echo $productname[$i];
            $i++;

    }

$names = explode('<|>', mysql_result(mysql_query(
    "SELECT GROUP_CONCAT(name separator '<|>') FROM products GROUP BY 'name'"
), 0));