array

[vronsky]

Maybe toomuch beer yesterday night.

if I have

$query = "SELECT id FROM single_product ";
$result = mysql_query($query);
$num = mysql_num_rows($result);
	for($i=0;$i< $num;$i++){
	$row = mysql_fetch_array($result);
	$number = $row[0];
	$array=array($number,$i);
	} 
	print_r($array);  

Of course only the last values are added to the array.
Can't figure how all the values in my cycle could be added to the array.

Sorry.
Thanks.

[vronsky]

Sorry, I told : too much beer.

$query = "SELECT id FROM single_product WHERE  id_products_family=$id_lin AND id_products = $id_cat";
	$result = mysql_query($query);
    if (!$result) {echo "Invalid SQL ";} 
	$num = mysql_num_rows($result);
	$pollo=array();
	for($i=0;$i< $num;$i++){
	$row = mysql_fetch_array($result);
	$numero = $row[0];
	//$pollo=array($numero,$i);
	$pollo[$i]=$numero;

} 
print_r($pollo); 

[nemonoman]

looks like your code adds each new $numero to $pollo. Slightly simpler would be

$query = "SELECT id FROM single_product WHERE  id_products_family=$id_lin AND id_products = $id_cat";

if (!$result = mysql_query($query)) {echo "Invalid SQL ";} 
while($row = mysql_fetch_array($result)){
     $pollo[]=$row[0];
} 
print_r($pollo);

What's the problem? What isn't happening that you want to happen??