메인페이지에 그림 한개 불러오기 채택완료

열린이글​님, 놀지말구일해님,​ 카츠님 

답변 주셔서 감사합니다.​

doremi 님 혹시 게시판에

<?

$sql_chl="SELECT  * FROM `g5_write_pic_03` where ORDER BY `g5_write_notice`.`wr_id` ASC LIMIT 0,3 ";

$opt_chl = sql_fetch($sql_chl);

$sql_chl_img="SELECT * FROM `g5_board_file` where bo_table='pic_03' and wr_id='$opt_chl[wr_id]' ";

$i=0;

while($opt_chl_img = sql_fetch($sql_chl_img)){

$picpic[$i]=$opt_chl_img[bf_file];

$i++;

}

echo picpic[2];

?> 

이렇게 하신거예요?? 

열린이글 님 감사합니다.

소스의 뒷부분에 " 나 ; 등이 빠진것 같아서 

아래와 같이 수정해 보았으니 수정전과 같이 SQL syntax​ error 가 나옵니다.

맞는지 한번 확인해 주시겠습니까?

<?

$sql_chl="SELECT  * FROM `g5_write_pic_03` where ORDER BY `g5_write_notice`.`wr_id` ASC LIMIT 0,3 ";

$opt_chl = sql_fetch($sql_chl);

$sql_chl_img="SELECT * FROM `g5_board_file` where bo_table='pic_03' and wr_id='$opt_chl[wr_id]' ";

$i=0;

while($opt_chl_img = sql_fetch($sql_chl_img)){

$picpic[$i]=$opt_chl_img[bf_file];

$i++;

}

echo picpic[2];

?> 

$sql_chl="SELECT  * FROM `g5_write_aaa` where ORDER BY `g5_write_notice`.`wr_id` ASC LIMIT 0 , 3 

                                        aaa게시판에                                                                                세번째글  

    $opt_chl = sql_fetch($sql_chl);

$sql_chl_img="SELECT * FROM `g5_board_file` where bo_table='aaa' and wr_id='$opt_chl[wr_id]'

$i=0;

while($opt_chl_img = sql_fetch($sql_chl_img)){

$picpic[$i]=$opt_chl_img[http://ruwa64-069.fmcity.com/WebMysql/sql.php?db=cjlove_cj102&table=g5_board_file&token=fce718ff3f18655402f6e00eb98baf95&sql_query=SELECT+%2A+FROM+%60g5_board_file%60+ORDER+BY+%60g5_board_file%60.%60bf_file%60+ASC">bf_file];

$i++;

}

echo picpic[2];

두번째 첨부된 화일

문제있으면 열락주세요