using simultaneous arrays

I have a table with each column containing the following form objects -
combobox, hidden field, textarea, and tick box. I have created arrays from
each of these columns and now I wish to use the arrays altogether, taking
each array element in order to use in an sql statement
Does anyone know how to use arrays simultaneously
eg
Array1 - 1,2,3
Array2 - text1,text2,text3
Array3 - 31,56,34
Aray4- 1,1,0

used in a loop to populate the following SQLs
SQL="UPDATE mytable SET fieldA=Array2[0], fieldB=Array3[0], fieldC=Array4[0]
WHERE Index=Array1[0]"
SQL="UPDATE mytable SET fieldA=Array2[1], fieldB=Array3[1], fieldC=Array4[1]
WHERE Index=Array1[1]"
etc
for all the elements in the array

Ian

Hi Ian

You could simply use a multidimensional array ;)

Like

$AllItems = array();

for($i = 0; $i < 10; ++$i)
{
$TestData = Array($i,$i*2,"Foo, ");
array_push($AllItems, $TestData );
}

Then you can access your array via $AllItems[ any valid index]

maybe this is what you want

Best regards

"Ian Davies" <iandan.dav@virgin.net> wrote:
> I have a table with each column containing the following form objects -
> combobox, hidden field, textarea, and tick box. I have created arrays from
> each of these columns and now I wish to use the arrays altogether, taking
> each array element in order to use in an sql statement
> Does anyone know how to use arrays simultaneously
> eg
> Array1 - 1,2,3
> Array2 - text1,text2,text3
> Array3 - 31,56,34
> Aray4- 1,1,0
>
> used in a loop to populate the following SQLs
> SQL="UPDATE mytable SET fieldA=Array2[0], fieldB=Array3[0], fieldC=Array4[0]
> WHERE Index=Array1[0]"
> SQL="UPDATE mytable SET fieldA=Array2[1], fieldB=Array3[1], fieldC=Array4[1]
> WHERE Index=Array1[1]"
> etc
> for all the elements in the array

<?

for ($i = 0; $i < count($Array1); $i++)
{
$sql = "update mytable
set fieldA = {$Array2[$i]},
fieldB = {$Array3[$i]},
fieldC = {$Array4[$i]},
where Index = {$Array1[$i]}";
mysql_query($sql);
}

?>

miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu

cheers
thanks
That works fine
Ian


"Miguel Cruz" <spam@admin.u.nu> wrote in message
news:spam-16BC9D.00511229072006@localhost...
> "Ian Davies" <iandan.dav@virgin.net> wrote:
> > I have a table with each column containing the following form objects -
> > combobox, hidden field, textarea, and tick box. I have created arrays
from
> > each of these columns and now I wish to use the arrays altogether,
taking
> > each array element in order to use in an sql statement
> > Does anyone know how to use arrays simultaneously
> > eg
> > Array1 - 1,2,3
> > Array2 - text1,text2,text3
> > Array3 - 31,56,34
> > Aray4- 1,1,0
> >
> > used in a loop to populate the following SQLs
> > SQL="UPDATE mytable SET fieldA=Array2[0], fieldB=Array3[0],
fieldC=Array4[0]
> > WHERE Index=Array1[0]"
> > SQL="UPDATE mytable SET fieldA=Array2[1], fieldB=Array3[1],
fieldC=Array4[1]
> > WHERE Index=Array1[1]"
> > etc
> > for all the elements in the array
>
> <?
>
> for ($i = 0; $i < count($Array1); $i++)
> {
> $sql = "update mytable
> set fieldA = {$Array2[$i]},
> fieldB = {$Array3[$i]},
> fieldC = {$Array4[$i]},
> where Index = {$Array1[$i]}";
> mysql_query($sql);
> }
>
> ?>
>
> miguel
> --
> Photos from 40 countries on 5 continents: http://travel.u.nu
> Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
> Airports of the world: http://airport.u.nu