Dynamically name an array (or any variable for that matter)

[dafydd]

Hi,

 

I am trying to create a series of arrays from a database using a while loop.  I want to end up with $array1, $array2, $array3....$arrayn.

 

 

In the code below i have used ".$n" to illustrate what i am trying to do but i know that this isn't the way :-)

 

$sql_offers = "SELECT * FROM special_offers";
	$result_offers = mysql_query($sql_offers);
    if (mysql_num_rows($result_offers) > 0)
	{
$n='1';
	while($row_offers = mysql_fetch_array($result_offers))
		{
   $array_offers[]=$row_offers['p_id'];
   $array_offers[]=$row_offers['offer_id'];
   $array_offers[]=$row_offers['description'];
   $array_offers[]=$row_offers['added'];
   $array_offers[]=$row_offers['discount'];
$n++;
		}
    }

 

Any ideas?

 

Thanks

 

Dafydd

[per1os]

No clue why, but ok

 

<?php
$sql_offers = "SELECT * FROM special_offers";
	$result_offers = mysql_query($sql_offers);
    if (mysql_num_rows($result_offers) > 0)
	{
$n=1;
	while($row_offers = mysql_fetch_array($result_offers))
		{
                           $array_name = 'array'.$n;
   $$array_name = $row_offers;
$n++;
		}
    }

echo print_r($array1);
?>

[kenrbnsn]

I would use a two-dimensional array instead of many arrays:

<?php
$sql_offers = "SELECT * FROM special_offers";
$result_offers = mysql_query($sql_offers);
$n=0;
if (mysql_num_rows($result_offers) > 0){
   while($row_offers = mysql_fetch_array($result_offers)) {
       $array_offers[$n] = array();
       $array_offers[$n][]=$row_offers['p_id'];
       $array_offers[$n][]=$row_offers['offer_id'];
       $array_offers[$n][]=$row_offers['description'];
       $array_offers[$n][]=$row_offers['added'];
       $array_offers[$n][]=$row_offers['discount'];
       $n++;
   }
}
?>

Doing it this way makes it much easier to use later in your code.

 

Ken

[dafydd]

Thanks both.

 

frost110 - Its for a function i need to use on a shop site with some difficult legacy code.

 

Cheers

 

Dafydd