sql manipulations

jomapi

Guppy
hey guys i need some help,

in my database i hav fields named choice1, choice2, choice3...choice10

now in my php code is there any way where i can make my fields an array, heres my code:

$ctr=1;
while($ctr <=10){
$sql = "UPDATE `poll_data` SET `vote[$ctr]`='".$Votes['$ctr']."', `Votes`='$TotalVotes' WHERE `ID` = '". $PollData['ID'] . "' LIMIT 1";
$ctr++;
}

on the area after SET, is there a way that can happen?
 
Back
Top