답변 3개 / 댓글 4개
채택된 답변
+20 포인트
리스트 페이지 이면
if($list[$i]['wr_'.$j]) echo "<li>".$list[$i]['wr_'.$j]."</li>";
답변에 대한 댓글 3개
채택 감사 합니다.
[code]
<?php
$sql = "SELECT bo_table, bo_subject FROM {$g5['board_table']} ORDER BY gr_id, bo_table";
$result = sql_query($sql);
$query = "SHOW COLUMNS FROM " . G5_TABLE_PREFIX . "write_{$bo_table} LIKE 'wr_%'";
$result2 = sql_query($query);
$max_column_num = 0;
$max_column_name = '';
while ($column = sql_fetch_array($result2)) {
$column_name = $column['Field'];
$column_num = preg_replace('/[^0-9]/', '', $column_name);
if ($column_num > $max_column_num) {
$max_column_num = $column_num;
$max_column_name = $column_name;
}
}
$wr_last_num = explode("wr_", $max_column_name)[1];
while ($row = sql_fetch_array($result)) {
for ($k = 1; $k <= $wr_last_num; $k++) {
$qq = sql_fetch("SHOW COLUMNS FROM " . G5_TABLE_PREFIX . "write_{$row['bo_table']} LIKE 'wr_{$k}'");
if (!$qq) continue;
if ($qq['Type']) $rr = explode("wr_", "wr_{$k}")[1];
}
}
for ($i = 1; $i <= $rr; $i++) {
if(isset($view['wr_'.$i])) echo $view['wr_'.$i].' ';
}
?>
[/code]
[code]
<?php
$sql = "SELECT bo_table, bo_subject FROM {$g5['board_table']} ORDER BY gr_id, bo_table";
$result = sql_query($sql);
$query = "SHOW COLUMNS FROM " . G5_TABLE_PREFIX . "write_{$bo_table} LIKE 'wr_%'";
$result2 = sql_query($query);
$max_column_num = 0;
$max_column_name = '';
while ($column = sql_fetch_array($result2)) {
$column_name = $column['Field'];
$column_num = preg_replace('/[^0-9]/', '', $column_name);
if ($column_num > $max_column_num) {
$max_column_num = $column_num;
$max_column_name = $column_name;
}
}
$wr_last_num = explode("wr_", $max_column_name)[1];
while ($row = sql_fetch_array($result)) {
for ($k = 1; $k <= $wr_last_num; $k++) {
$qq = sql_fetch("SHOW COLUMNS FROM " . G5_TABLE_PREFIX . "write_{$row['bo_table']} LIKE 'wr_{$k}'");
if (!$qq) continue;
if ($qq['Type']) $rr = explode("wr_", "wr_{$k}")[1];
}
}
for ($i = 1; $i <= $rr; $i++) {
if(isset($view['wr_'.$i])) echo $view['wr_'.$i].' ';
}
?>
[/code]
참고를 해보세요~
<ul>
<?php
for ($j = 1; $j <= 8; $j++) {
$field = 'wr_' . $j;
if (!empty($view[$i][$field])) {
echo "<li>" . $view[$i][$field] . "</li>";
}
}
?>
</ul>
답변을 작성하려면 로그인이 필요합니다.