如何从SQL中的表中每次选择两行并在PHP中显示它们？

Question

I have a table with fields like id, date, heading, news. I want to display the fields date, heading and news in an Owl Carousel slider. Can anyone suggest how to pick two rows at a time from an SQL table to display two entries at a time in the Owl Carousel slider. I have used an SQL query like this:

<?php
$sql3 = "SELECT date, heading, news FROM news ORDER BY news.date LIMIT 0, 1";
$result3 = mysql_query($sql3) or die(mysql_error());
while($row3 = mysql_fetch_array($result3)) {
    ?>
    <div class="item ">
        <div class="l_blk">
            <div class="news_container">
                <div class="col-md-1 date_b"><p>Mar<br>09</p></div>
                <div class="col-md-11 cont_b">
                    <p>
                        <span class="news_t">"<?php echo $row3['heading']; ?>"</span><br>
                        <?php echo $row3['news']; ?>
                    </p>
                </div>
            </div>
        </div>
        <div class="l_blk">
            <div class="news_container">
                <div class="col-md-1 date_b"><p>Mar<br>09</p></div>
                <div class="col-md-11 cont_b">
                    <p>
                        <span class="news_t">"<?php echo $row3['heading']; ?>"</span><br>
                        <?php echo $row3['news']; ?>
                    </p>
                </div>
            </div>
        </div>
    </div>
    <?php
}
?>

Can anyone suggest how to do this?

Answer 1

$sql3 = "SELECT date, heading, news FROM news  ORDER BY news.date LIMIT 0, 1";

Don't you change the LIMIT 0, 2

Which means select 2 starting with the value at index 0?

Once you've done that, take out the duplicate code inside the loop