Help with Simple Array

[Canman2005]

Hi all

 

I have the following PHP

 

$q = mysql_query("SELECT * FROM `people` WHERE `type` = 1");
while($r = mysql_fetch_array($q))
{
echo $r['product'];
echo "<br>";
}

 

This produces

 

1

3

6

13

 

which works great.

 

But i'm trying to create an array containing those values, so I get something like

 

array(1, 3, 6, 13)

 

How can I achive this?

 

I've tried

 

$q = mysql_query("SELECT * FROM `people` WHERE `type` = 1");
while($r = mysql_fetch_array($q))
{
$ray = $ray. array($r['product'].',');
}

 

but that doesn't seem to work and no matter how I tweak it, it doesn't seem to work.

 

Can anyone help?

 

Thanks very much

 

Dave

[Psycho]

$q = mysql_query("SELECT * FROM `people` WHERE `type`=1");

$products = array();
while($r = mysql_fetch_array($q))
{
     $products[] = $r['product'];
}

[Canman2005]

thanks dude, worked a charm