쿼리문 댓글

<div class="last_ranking">

  <div class="inner">

    <h2>지난주 랭킹</h2>

    <ul class="last_ranking_list">

      <?php

        $sql = "SELECT * FROM g5_write_gallery WHERE  wr_datetime < '2021-11-01 10:00:00' AND wr_datetime > '2021-10-26 17:50:00' HAVING NOT wr_option LIKE '%secret%' ORDER BY wr_1 DESC LIMIT 3 ";

        $result = mysqli_query($connect, $sql);

        $list='';

        $num = 0;

 

        while($row = mysqli_fetch_array($result)){

          $num ++;

          $thumb = get_list_thumbnail('gallery', $row['wr_id'], 202, 179, false, true);

          if($thumb['src']) {

            $img_content = '<img src="'.$thumb['src'].'" alt="'.$thumb['alt'].'" >';

          } else {

            $img_content = '이미지 없을때';

          }

      ?>  

      <li>

        <div>

          <div class="last_ranking_img">

            <p><?= $num ?></p>

            <?php echo run_replace('thumb_image_tag', $img_content, $thumb); ?>

          </div>

          <div class="last_ranking_info">

            <ul>

              <li><?= $row['wr_name'] ?></li>

              <li><?= $row['wr_2'] ?></li>

              <li><?= $row['wr_1'] ?>cm</li>

              <li><?= $row['wr_3'] ?></li>

            </ul>

          </div>  

        </div>

      </li>

      <?php } ?>

  </li>