for문으로 만들려고 하는데 에러가 납니다.
본문
아래 코드를 for문으로 만들려고 하는데 잘 안됩니다. 도움 부탁 드려요~
<?
for ($c=0; $c<4; $c++) {
$color_{$c} = 0;
$sql_{$c} = "select wr_4 from g5_write_test where wr_2 = '1' ;
$result_{$c} = sql_query($sql_{$c});
while ($row_{$c} = sql_fetch_array($result_{$c})) {
$color_{$c} += (int)$row_{$c}['wr_4'];
}
}
?>
<?
$color_1 = 0;
$sql_1 = "select wr_4 from g5_write_test where wr_2 = '1';
$result_1 = sql_query($sql_1);
while ($row_1 = sql_fetch_array($result_1)) {
$color_1 += (int)$row_1['wr_4'];
}
$color_2 = 0;
$sql_2 = "select wr_4 from g5_write_test where wr_2 = '1';
$result_2 = sql_query($sql_2);
while ($row_2 = sql_fetch_array($result_2)) {
$color_2 += (int)$row_2['wr_4'];
}
$color_3 = 0;
$sql_3 = "select wr_4 from g5_write_test where wr_2 = '1';
$result_3 = sql_query($sql_3);
while ($row_3 = sql_fetch_array($result_3)) {
$color_3 += (int)$row_3['wr_4'];
}
?>
답변 1
쿼리문쪽 변수는 굳이 다르게 주지 않다고 될듯 합니다.
<?
for ($c=1; $c<4; $c++) {
${'color_'.$c} = 0;
$sql = "select wr_4 from g5_write_test where wr_2 = '1' ;
$result = sql_query($sql);
while ($row = sql_fetch_array($result)) {
${'color_'.$c} += (int)$row['wr_4'];
}
}
?>