SQL Results into Array

[NZ_Kiwis]

$result = mysql_query ("SELECT COUNT(*), HitNumber, VisitTime FROM COUNTER GROUP BY FROM_UNIXTIME(VisitTime, '%Y-%m-%d')") or die("INSERT error: ".mysql_error());
WHILE ($row = mysql_fetch_array($result)){
$replies =  $row[0];
$time = $row['VisitTime'];
$id = $row['HitNumber'];
$time2 = strftime("%A %d/%m/%y", $time);
 }




    $data = array('');
    $x_fld = array('');

I want the $replies to go in the $data array and the $time to go in the X_fld array.... how can i do this???

[leatherback]

$data = array();
$x_fld = array(); 

$result = mysql_query ("SELECT COUNT(*), HitNumber, VisitTime 
    FROM COUNTER 
    GROUP BY FROM_UNIXTIME(VisitTime, '%Y-%m-%d')") or 
    die("INSERT error: ".mysql_error());

WHILE ($row = mysql_fetch_array($result)){
  $data[] = $row[0];
  $x_fid[] =  $row['VisitTime']; 
  $id = $row['HitNumber'];
  $time2 = strftime("%A %d/%m/%y", $time);
  }

[NZ_Kiwis]

HOw would I echo this array to check what's in there?

[laserlight]

If you are just checking, use [man]print_r/man or [man]var_dump/man.