need HELP

**wayz1229** · 11-13-2009, 12:21 PM

can anyone teach me how to do loop for the script below.. thanks in advance..

Code:

<?php
require_once('config.php');
 
 $aid1=$_POST['Question-1'];
 $aid2=$_POST['Question-2'];
 $aid3=$_POST['Question-3'];
 $aid4=$_POST['Question-4'];
 $aid5=$_POST['Question-5'];
 $aid6=$_POST['Question-6'];
 $aid7=$_POST['Question-7'];
 $aid8=$_POST['Question-8'];
 $aid9=$_POST['Question-9'];
 $aid10=$_POST['Question-10'];
 
 $qid1=$_POST['qid1'];
 $qid2=$_POST['qid2'];
 $qid3=$_POST['qid3'];
 $qid4=$_POST['qid4'];
 $qid5=$_POST['qid5'];
 $qid6=$_POST['qid6'];
 $qid7=$_POST['qid7'];
 $qid8=$_POST['qid8'];
 $qid9=$_POST['qid9'];
 $qid10=$_POST['qid10'];
 
 
    // update vote counter
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid1' AND qid = '$qid1'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid2' AND qid = '$qid2'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid3' AND qid = '$qid3'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid4' AND qid = '$qid4'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid5' AND qid = '$qid5'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid6' AND qid = '$qid6'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid7' AND qid = '$qid7'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid8' AND qid = '$qid8'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid9' AND qid = '$qid9'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid10' AND qid = '$qid10'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
    // close connection
    mysql_close();
?>

**orionoreo** · 11-13-2009, 01:55 PM

PHP Code:


			
<?php
require_once('config.php');
 
 for ($i = 1; $i<=10; $i++) {
    $aid = $_POST['Question-'.$i];
    $qid = $_POST['qid'.$i];
    
    // update vote counter
     $query = "UPDATE answers SET acount = acount + $i WHERE aid = '$aid' AND qid = '$qid'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 }

 // close connection
 mysql_close();
 
?>