메인에 메뉴명(대메뉴) 불러오기

방법 1

<?php 
    $sql = "select * from stamp_menu where length(me_code) = 2 order by me_id limit 0, 5";
    $result = sql_query($sql);
    $total = sql_num_rows($result);

?>

<?php for($i=0;$row=sql_fetch_array($result);$i++){ ?>
   <?php echo $row['me_name']?>
<?php }?>

 

방법2

<?php 
    $sql = "select me_name from g5_menu where length(me_code) = 2 and me_use = 1 order by me_id desc";
    $result5 = sql_query($sql);
    for ($F=0; $row=sql_fetch_array($result5); $F++) {
       echo $row[me_name]."<br> 123";
    }

?>

<?php for($i=0;$row=sql_fetch_array($result);$i++){ ?>
   <?php echo $row['me_name']?>
<?php }?>

 

방법3

<?php 
    $sql = "select me_name from g5_menu where length(me_code) = 2 and me_use = 1 order by me_id desc";
    $result5 = sql_query($sql);
    for ($F=0; $row=sql_fetch_array($result5); $F++) {
       echo $row[me_name]."<br> 123";
    }

?>

<?php for($i=0;$row=sql_fetch_array($result);$i++){ ?>
   <?php echo $row['me_name']?>
<?php }?>