Posted by Miguel Cruz on 07/28/06 16:51

"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

• Next in forum: Generate map on the fly, specifying colors for defined regions?
• Prev in forum: Comma delimited file
• Thread view: Re: using simultaneous arrays

[Reply to this message]