PHP - while循环改变 - PHP - while loop change

PHP - while loop change

本文关键字：改变循环 while PHP | 更新日期: 2023-09-27

我有下面的while循环。

$readNews_SQLselect = "SELECT  ";
$readNews_SQLselect .= "id, content ";  // rows names
$readNews_SQLselect .= "FROM ";
$readNews_SQLselect .= "news ";         // table name

$readNews_SQLselect_Query = mysql_query($readNews_SQLselect);   
//$indx = 1;    
while ($row = mysql_fetch_array($readNews_SQLselect_Query, MYSQL_ASSOC)) {
    $ID = $row['id'];
    $CONTENT = $row['content'];
    echo '<li>' . $ID .' ' . $CONTENT . '</li>';
    //$indx++;
}
mysql_free_result($readNews_SQLselect_Query);

如果我添加'$LIVE = $row['live'];'的条件是只显示live值字符串为'0'的行，它会怎么样? Live将为0/1 (VARCHART)。

只需将此添加到您的查询中:

$readNews_SQLslect .= " WHERE live = '0'";

Alter $readNews_SQLselect

$readNews_SQLselect = "SELECT  ";
$readNews_SQLselect .= "id, content ";   // rows names
$readNews_SQLselect .= "FROM ";
$readNews_SQLselect .= "news ";          // table name
$readNews_SQLselect .= "WHERE live='0'"; // condition

修改sql:

$readNews_SQLselect = "SELECT  ";
$readNews_SQLselect .= "id, content ";  // rows names
$readNews_SQLselect .= "FROM ";
$readNews_SQLselect .= "news ";         // table name
$readNews_SQLselect .= "where live = '0' ";

if ($row['live'] == '0') { echo '<li>' . $ID .' ' . $CONTENT . '</li>'; }