如何在SQL中每次从表中选择两行并在PHP中显示 - How to select two rows each time from a table in SQL and display them in PHP?

How to select two rows each time from a table in SQL and display them in PHP?

本文关键字：两行 PHP 显示 SQL 选择 | 更新日期: 2023-09-27

我有一个包含id、date、heading、news等字段的表。我想在Owl旋转木马滑块中显示字段date、heading和news。有人能建议如何从SQL表中一次选择两行，以便在Owl Carousel滑块中一次显示两个条目吗。我使用了这样一个SQL查询：

<?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
}
?>

有人能建议怎么做吗？

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

你不改变极限0，2 吗

这意味着从索引0处的值开始选择2？

完成后，取出循环中的重复代码

请尝试这个。

<?php
$sql3 = "SELECT date, heading, news FROM news  ORDER BY news.date"; // No limit
$result3= mysql_query($sql3) or die(mysql_error());
$counter = 0;
while($row3 = mysql_fetch_array($result3, MYSQL_ASSOC))
{
    if($counter % 2 == 0){
        echo '<div class="item ">'.PHP_EOL;
    }
    ?>
        <div class="l_blk">
            <div class="news_container">
                <div class="col-md-1 date_b"><?php $row3['date'] ?></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>
<?php
    if($counter % 2 == 1){
    echo '</div>'.PHP_EOL;
    }
    $counter++;
}
if($counter % 2 == 1){
    echo '</div>'.PHP_EOL;
}
?>