while문을 돌려 레코드 값이 계속 돌리고 싶은데..어떻게 해야될지...
for를 써서 돌리는 방법좀...........
<?$query = "SELECT * FROM zunRESULT where USER_ID = '$USER_ID' AND TEST_NAME > 1 order by TEST_NAME desc";
.
.
.
while($row = mysql_fetch_array($result)) {
$my_test_name = $row["TEST_NAME"];
$my_section_type = $row["SECTION_TYPE"];
$my_test_score = $row["TEST_SCORE"];
$my_max_score = $row["MAX_SCORE"];
switch($my_section_type) {
case (1):
$w = 5;
$l = 0;
$s = 0;
$r = 0;
$W = $w*$my_test_score;
break;
case (2):
$w = 0;
$l = 5;
$s = 0;
$r = 0;
$L = $l*$my_test_score;
break;
case (3):
$w = 0;
$l = 0;
$s = 5;
$r = 0;
$S = $s*$my_test_score;
break;
case (4):
$w = 0;
$l = 0;
$s = 0;
$r = 3;
$R = $r*$my_test_score;
break;
default :
}
$sum = $W+$L+$S+$R;
$pe = $my_test_score/$my_max_score*100;
$per = substr("$pe",0,4);
}
echo("
<tr>
<td align=center>$my_test_name</td><td align=center>$W</td>
<td align=center>$L</td>
<td align=center>$S</td>
<td align=center>$R</td>
<td align=center>$sum</td>
<td aling=center>$per</td>
</tr>
");
?>