채택완료

while 문 질문 입니다.

Copy
<?
$tname = "education_course";
$num_per_page = 4;

//기본쿼리 - 현재모집중인것만 셀렉트
$sql_board = "SELECT * FROM ".$tname." where idx!='' and e_state=1 and e_category=4";

$cntRcd = countRecordSql($db, $tname, $key, $keystring, $num_per_page, $page , $sql_board );

$sql_board = $sql_board . " order by idx desc LIMIT ".$cntRcd[0]." , ".$num_per_page ;

$res = $db->Query($sql_board);
$cnt = 0;
while($row = mysql_fetch_array($res))
{
    if($row[e_category]==1) $category_img = '<img src="../images/main/online_icon1.gif" border="0" alt="우선선정직종" align="absmiddle">';
    if($row[e_category]==2) $category_img = '<img src="../images/main/online_icon2.gif" border="0" alt="실업자과정" align="absmiddle">';
    if($row[e_category]==3) $category_img = '<img src="../images/main/online_icon3.gif" border="0" alt="계좌제과정" align="absmiddle">';
    if($row[e_category]==4) $category_img = '<img src="../images/main/online_icon4.gif" border="0" alt="제직자과정" align="absmiddle">';
    if($row[e_category]==5) $category_img = '<img src="../images/main/online_icon5.gif" border="0" alt="일반/방학특강" align="absmiddle">';
    if($row[e_category]==6) $category_img = '<img src="../images/main/online_icon6.gif" border="0" alt="위탁교육" align="absmiddle">';
?>
                                                    <tr>
                                                        <td class="m-latest-name"><?=$category_img?> <?=$classStrCut->cut($row[e_name],150)?></td>
                                                        <td class="m-latest-date"><?=date("Y.m.d",$row[e_opendate])?>(<?=$row[e_time]?>)</td>
                                                        <td class="m-latest-link"><a href="../community/nboard_list.htm?mode=write&tname=nboard_board"><img src="../images/main/online_btn.gif"></a></td>
                                                    </tr>
<?
}
?>

 

for문은 알겠는데 while문은 이럴경우 

 

if(데이터가 없으면) { echo"데이터가 없습니다."; } 이걸 어떻게 처리해야 하나요?

|

답변 1개

채택된 답변
+20 포인트

체크값이 e_category 경우
if(!$row[e_category]) { echo"데이터가 없습니다."; }

답변을 작성하려면 로그인이 필요합니다.