Variables on the fly??

furious5

I have ran an sql statement and returned the array.

I am now trying to iterate through the array and create individual variables on the fly e.g week1, week2, week3 for as many records as there are in the array.

Does anyone have any ideas on how I can achieve this??

At the moment the code looks like this however I'm not having any success:


$week = "week";
$i = "1";

while ($row_FormFields = mysql_fetch_array($FormFields)){

$week.${$i} = $row_FormFields['week'];
$price = $row_FormFields['price'];
$availability.$i = $row_FormFields['availability'];

$i ++;

}

devinemke

I assume you have a (numeric) primary key field in the table. Assuming that field is called "ID", I suggest the following:

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

extract ($row);

$array[$ID] = array (
'week' => $week,
'price' => $price,
'availability' => $availability
);

}

now you can refer to your elements like this:

echo $array[5]['price']; // outputs the price for record #5
echo $array[14]['availability']; // outputs the availability for record #14

leatherback

...
Are you sure this is the way you want to do this!? I don't know what you are trying to achieve, but there must be a better way of doing this. Look at arrays?

$varbase = "week"
$i =1;

while ....
{
 $var = $varbase.$i;
 $$var = "The content you want for this week"
 $i++;
 }

Should create your variables. You place the content or each week in the bracketet section.

-- In case you want to work with arrays: Look at the post above this one. Hm.. Must be getting slow! --

furious5

Thanks guys.

I would normally use an array, but I have to feed the values in to a BIG form, which is doing alot of processing. The way leatherback has illustrated is the best way I need to achieve what I needed to do.

Thanks again, and happy new year.

lazzerous

if you're just looking for variable names created on the fly, you can do something like this:

for ($i=0; $i<$whatever; $i++)
    {
    ${"week".$i} = "whatever";
    }

This variable can now be referenced as $week1 or in a loop with a numeric operator (let's say $i): ${"week".$i}

-=Lazzerous=-