Variables in Variables

[Kevin_Isley]

I have variables from a form being passed into a page that updates my database...

There are multiple records to update all at once so I'm using a $num variable as my counter, which gets incremented every type it goes through a loop.

The problem here is that I need for example marked to be SET to $mark1, picture to be set to $pic1 etc... WHERE listFileId = $id1.

Then the next set would be $mark2, pic2, id2, etc......

But this isnt working like I planned.

For some reason the data isn't being processed out of the variable it's in, and being processed again as a the variable that is being passed from the prior page.

Can anyone help with this??? Or give me another suggestion???

$num = 1;
for ($i = 0; $count > $i; $i++){

$mark = "/$mark$num";
$pic = "/$pic$num";
$ad = "/$ad$num";
$id = "/$id$num";

$Query = "UPDATE listfile SET marked = '$mark', picture = '$pic', adDesc = '$ad' WHERE listFileId = '$id'";
$Result2 = mysql_query($Query);
if (!Result2){
echo "Error in Query.";
}

echo "$mark  $pic   $ad    $id<br>";

$num++;
}

Thanks again.

Kevin

[LordShryku]

Try using the $POST or $GET variable, depending what method you're using...

$mark = $_POST['mark'.$num];

[Kevin_Isley]

Yeah, but why can't I just use globals??

[LordShryku]

You could I guess, but you'd need to use variable variables(look it up). Using the non global way is just cleaner.

[Sxooter]

If you're gonna use globals, then just make them arrays to start with, so you can avoid variable variables.

i.e. your forms look like this:

<form name...
<input type="text" name="last_name[0]"...
<input type="text" name="first_name[0]"...
<input type=...
...
<input type="text" name="last_name[22]"...
<input type="text" name="first_name[22]"

They're easy to generate by php code, and easy to parse back on input.