<?
$sql_list = "
select
SUM(IF(wr_9 = 'Telephone', wr_10,0)) AS `communication`,
SUM(IF(wr_9 = 'Book', wr_10,0)) AS `stationary`,
SUM(IF(wr_9 = 'Apple', wr_10,0)) AS `fruit`
SUM(IF(wr_9 = 'Asian', wr_10,0)) AS `people`
SUM(IF(wr_9 = 'Eagle', wr_10,0)) AS `bird`
SUM(IF(wr_9 = 'Snapper', wr_10,0)) AS `fish`
SUM(IF(wr_9 = 'tiger', wr_10,0)) AS `cat`
SUM(IF(wr_9 = 'baekdu', wr_10,0)) AS `mountain`
SUM(IF(wr_9 = 'skytower', wr_10,0)) AS `building`
SUM(IF(wr_9 = 'rilly', wr_10,0)) AS `flower`

죽 계속...

from $write_table where wr_is_comment = 0 and wr_6 = '$stx' order by ca_name";

$row= sql_fetch($sql_list);
print_r($row);

$communication = $row[communication];
$stationary = $row[stationary];
$fruit = $row[fruit];
$people = $row[people];
$bird = $row[bird];
$fish = $row[fish];
$cat = $row[cat];
$mountain = $row[mountain];
$building = $row[building];
$flower = $row[flower];

죽 계속 ...
?>

위의 구문에서
======================================
$communication = $row[communication];
$stationary = $row[stationary];
$fruit = $row[fruit];
$people = $row[people];
$bird = $row[bird];
$fish = $row[fish];
$cat = $row[cat];
$mountain = $row[mountain];
$building = $row[building];
$flower = $row[flower];
=============================
이부분을 자동을 하려면 어떻게 해야할지 조언구합니다.
위의 sql 구문에
.
.
SUM(IF(wr_9 = 'rilly', wr_10,0)) AS `flower`
이렇게 수백개로 늘어나면
다시 밑에서
.
.
$flower = $row[flower];
이렇게 수백개 변경구문을 써줘야 하는데
밑의 변경부문을 자동화 하려면 어떻게 해야할지 막히는 군요.
조언 부탁드립니다.