묻고답하기
page_full_width" class="col-xs-12" |cond="$__Context->page_full_width">
MYSQL 구문에 문제가 있는 것 같습니다..ㅠㅠ
2012.08.15 23:31
<?
$connect = mysql_connect("localhost", "root", "psww");
mysql_select_db("xe");
mysql_query("set names utf8");
$result=mysql_query("select * from xe_documents where document_srl = $document_srl" ) or die(mysql_error());
$i=0;
while($data=mysql_fetch_array($result))
{
$result_text2=mysql_query("select * from xe_files where upload_target_srl = $data[document_srl] order by source_filename asc ") or die(mysql_error());
while( $data5=mysql_fetch_array($result_text2))
{$b_img[$i] = "".$data5[uploaded_filename];
$b_name[$i] = $data5[source_filename];
?>
<?if($data[module_srl] == 377){?>
<div class="slide" >
<img src="<?=$data5[uploaded_filename]?>" width="860">
</div>
<? } else { ?>
<?if(substr($b_name[$i],0,8)=='content_' || substr($b_name[$i],0,4)=='tmb_'){?>
<?}else{?>
<div class="slide" >
<img src="<?=$data5[uploaded_filename]?>" width="960">
</div>
<? } ?>
<? } ?>
<? $i++;
}
?>
<? } ?>
이 소스를 확인하면 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 이렇게 나오는데 ㅠㅠ 이유가 대체..
mysql은 5.14인것 같은데 ㅠㅠ