|
|
Posted by Ian Davies on 07/28/06 20:46
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
Navigation:
[Reply to this message]
|