DB 에러
본문
그누스킨G4 에 적용된 별점주기 : 정상 >> G5 에 사용하니 : 에러발생
그누보드 G4 에서는 정상
<?
$cmtpoint ='0';
$totalcount = '0';
$userrating = '0';
$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
$result2 = sql_query($sql2);
while($row2 = mysql_fetch_array($result2) ) {
$point=$row2[0];
$cmtpoint=$cmtpoint + $point;
$totalcount++;
}
if ($totalcount!=0) {
$cmtpoint= $cmtpoint/$totalcount;
$cmtpoint= number_format($cmtpoint,2);
}
echo "<a href='{$list[$i][href]}'>";
?>
그누보드 G5 에서는
<?
$cmtpoint ='0';
$totalcount = '0';
$userrating = '0';
$tbl = "{$g5[write_prefix]}{$bo_table}";
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
$result2 = sql_query($sql2);
line 344 : while($row2 = mysql_fetch_array($result2) ) {
$point=$row2[0];
$cmtpoint=$cmtpoint + $point;
$totalcount++;
}
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jone/public_html/theme/company/skin/board/fz_gallery_circle_/list.skin.php on line 344
if ($totalcount!=0) {
$cmtpoint= $cmtpoint/$totalcount;
$cmtpoint= number_format($cmtpoint,2);
}
echo "<a href='{$list[$i][href]}'>";
?>
아래 에러메시지
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jone/public_html/theme/company/skin/board/fz_gallery_circle_/list.skin.php on line 344