PHP/ > 그누4 질문답변

PHP/ 정보

PHP/

본문

글작성 페이지에서 글쓰기를 한후
뷰페이지에서 보면 적용이 안되어 질문합니다..ㅠㅠ

write.php

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<tr id="newUrl1" style="display:none">
<td class=write_head>기본료</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_13 id="wr_13" itemname="LTE 34" <?if($w==''){?>value="34000"<?}else{?>value="<?=$wr_13?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_14 id="wr_14" itemname="LTE 42" <?if($w==''){?>value="42000"<?}else{?>value="<?=$wr_14?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_15 id="wr_15" itemname="LTE 52" <?if($w==''){?>value="52000"<?}else{?>value="<?=$wr_15?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_16 id="wr_16" itemname="LTE 62" <?if($w==''){?>value="62000"<?}else{?>value="<?=$wr_16?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_17 id="wr_17" itemname="LTE 72" <?if($w==''){?>value="72000"<?}else{?>value="<?=$wr_17?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_18 id="wr_18" itemname="LTE 85" <?if($w==''){?>value="85000"<?}else{?>value="<?=$wr_18?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_19 id="wr_19" itemname="LTE 100" <?if($w==''){?>value="100000"<?}else{?>value="<?=$wr_19?>"<?}?>></td></tr>
<tr id="newUrl6" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl2" style="display:none">
<td class=write_head>무료통화</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_20 id="wr_20" itemname="LTE 34" <?if($w==''){?>value="120분"<?}else{?>value="<?=$wr_20?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_21 id="wr_21" itemname="LTE 42" <?if($w==''){?>value="180분"<?}else{?>value="<?=$wr_21?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_22 id="wr_22" itemname="LTE 52" <?if($w==''){?>value="250분"<?}else{?>value="<?=$wr_22?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_23 id="wr_23" itemname="LTE 62" <?if($w==''){?>value="350분"<?}else{?>value="<?=$wr_23?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_24 id="wr_24" itemname="LTE 72" <?if($w==''){?>value="450분"<?}else{?>value="<?=$wr_24?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_25 id="wr_25" itemname="LTE 85" <?if($w==''){?>value="650분"<?}else{?>value="<?=$wr_25?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_26 id="wr_26" itemname="LTE 100" <?if($w==''){?>value="1050분"<?}else{?>value="<?=$wr_26?>"<?}?>></td></tr>
<tr id="newUrl7" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl3" style="display:none">
<td class=write_head>무료문자</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_27 id="wr_27" itemname="LTE 34" <?if($w==''){?>value="200건"<?}else{?>value="<?=$wr_27?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_28 id="wr_28" itemname="LTE 42" <?if($w==''){?>value="200건"<?}else{?>value="<?=$wr_28?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_29 id="wr_29" itemname="LTE 52" <?if($w==''){?>value="250건"<?}else{?>value="<?=$wr_29?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_30 id="wr_30" itemname="LTE 62" <?if($w==''){?>value="350건"<?}else{?>value="<?=$wr_30?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_31 id="wr_31" itemname="LTE 72" <?if($w==''){?>value="450건"<?}else{?>value="<?=$wr_31?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_32 id="wr_32" itemname="LTE 85" <?if($w==''){?>value="650건"<?}else{?>value="<?=$wr_32?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_33 id="wr_33" itemname="LTE 100" <?if($w==''){?>value="1050건"<?}else{?>value="<?=$wr_33?>"<?}?>></td></tr>
<tr id="newUrl8" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl4" style="display:none">
<td class=write_head>무료데이터</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_34 id="wr_34" itemname="LTE 34" <?if($w==''){?>value="550MB"<?}else{?>value="<?=$wr_34?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_35 id="wr_35" itemname="LTE 42" <?if($w==''){?>value="1.1GB"<?}else{?>value="<?=$wr_35?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_36 id="wr_36" itemname="LTE 52" <?if($w==''){?>value="2GB"<?}else{?>value="<?=$wr_36?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_37 id="wr_37" itemname="LTE 62" <?if($w==''){?>value="5GB"<?}else{?>value="<?=$wr_37?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_38 id="wr_38" itemname="LTE 72" <?if($w==''){?>value="9GB"<?}else{?>value="<?=$wr_38?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_39 id="wr_39" itemname="LTE 85" <?if($w==''){?>value="13GB"<?}else{?>value="<?=$wr_39?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_40 id="wr_40" itemname="LTE 100" <?if($w==''){?>value="18GB"<?}else{?>value="<?=$wr_40?>"<?}?>></td></tr>
<tr id="newUrl9" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl5" style="display:none">
<td class=write_head>요금약정할인</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_120 id="wr_120" itemname="LTE 34" <?if($w==''){?>value="7700"<?}else{?>value="<?=$wr_120?>"<?}?> /> LTE 42 : <input class='ed' style="width:10%;" name="wr_121" id="wr_121" itemname="LTE 42" <?if($w==''){?>value="11550"<?}else{?>value="<?=$wr_121?>"<?}?> /> LTE 52 : <input class='ed' style="width:10%;" name=wr_122 id="wr_122" itemname="LTE 52" <?if($w==''){?>value="14850"<?}else{?>value="<?=$wr_122?>"<?}?> /> LTE 62 : <input class='ed' style="width:10%;" name=wr_123 id="wr_123" itemname="LTE 62" <?if($w==''){?>value="17600"<?}else{?>value="<?=$wr_123?>"<?}?> /><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_124 id="wr_124" itemname="LTE 72" <?if($w==''){?>value="19800"<?}else{?>value="<?=$wr_124?>"<?}?> /> LTE 85 : <input class='ed' style="width:10%;" name=wr_125 id="wr_125" itemname="LTE 85" <?if($w==''){?>value="22000"<?}else{?>value="<?=$wr_125?>"<?}?> /> LTE 100 : <input class='ed' style="width:10%;" name=wr_126 id="wr_126" itemname="LTE 100" <?if($w==''){?>value="26400"<?}else{?>value="<?=$wr_126?>"<?}?> /></td></tr>
<tr id="newUrl10" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

view.php

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<?}else{?>
<tr>
<td width="53" height="32" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">구분</font></strong></td>
<td width="93" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 34</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 42</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 52</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 62</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 72</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 85</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 100</font></strong></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">할부원금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">LTE플러스약정할인</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_100])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_101])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_102])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_103])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_104])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_105])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_106])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">할부금지원</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_107])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_108])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_109])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_110])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_111])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_112])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_113])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 고객 총부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]+$view[wr_100])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66]+$view[wr_101])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67]+$view[wr_102])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68]+$view[wr_103])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69]+$view[wr_104])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70]+$view[wr_105])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71]+$view[wr_106])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 월 부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]/$view[wr_114]-$view[wr_120])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66]/$view[wr_114]-$view[wr_121])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67]/$view[wr_114]-$view[wr_122])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68]/$view[wr_114]-$view[wr_123])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69]/$view[wr_114]-$view[wr_124])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70]/$view[wr_114]-$view[wr_125])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71]/$view[wr_114]-$view[wr_126])?></td>
</tr>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

write.php 소스에서

<tr id="newUrl5" style="display:none">
<td class=write_head>요금약정할인</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_120 id="wr_120" itemname="LTE 34" <?if($w==''){?>value="7700"<?}else{?>value="<?=$wr_120?>"<?}?> /> LTE 42 : <input class='ed' style="width:10%;" name="wr_121" id="wr_121" itemname="LTE 42" <?if($w==''){?>value="11550"<?}else{?>value="<?=$wr_121?>"<?}?> /> LTE 52 : <input class='ed' style="width:10%;" name=wr_122 id="wr_122" itemname="LTE 52" <?if($w==''){?>value="14850"<?}else{?>value="<?=$wr_122?>"<?}?> /> LTE 62 : <input class='ed' style="width:10%;" name=wr_123 id="wr_123" itemname="LTE 62" <?if($w==''){?>value="17600"<?}else{?>value="<?=$wr_123?>"<?}?> /><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_124 id="wr_124" itemname="LTE 72" <?if($w==''){?>value="19800"<?}else{?>value="<?=$wr_124?>"<?}?> /> LTE 85 : <input class='ed' style="width:10%;" name=wr_125 id="wr_125" itemname="LTE 85" <?if($w==''){?>value="22000"<?}else{?>value="<?=$wr_125?>"<?}?> /> LTE 100 : <input class='ed' style="width:10%;" name=wr_126 id="wr_126" itemname="LTE 100" <?if($w==''){?>value="26400"<?}else{?>value="<?=$wr_126?>"<?}?> /></td></tr>
<tr id="newUrl10" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>

위부분에 적용된 내용이

view.php 소스의

<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 월 부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]/$view[wr_114])-$view[wr_120])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_66]/$view[wr_114])-$view[wr_121])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_67]/$view[wr_114])-$view[wr_122])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_68]/$view[wr_114])-$view[wr_123])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_69]/$view[wr_114])-$view[wr_124])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_70]/$view[wr_114])-$view[wr_125])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_71]/$view[wr_114])-$view[wr_126])?></td>
</tr>

여기 적용이 되어야 하는데 전혀 적용이안되거든요-0-
나누기는 되는데 그다음 빼기가...안되네요...-0-

복사
공유하기

( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '253156' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )

1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

error file : /15sir/bbs/board.php

그누4 질문답변

본문

공유하기