while循环只读取第一个匹配而忽略其他匹配

Question

The problem is the code skips the first echo statement no matter what.

$query = mysql_query("SELECT index_no, lesson FROM c8_lessons_list WHERE   index_no ='456'");

($row = mysql_fetch_array($query));

if ($row['index_no'] !== '456' && $row['lesson'] !== "Fertilisation process"  )
{
    echo '<a href="file:///D|/CC-Gate/localhost">Fertilisation process</a>';
}
else
{
    echo 'Fertilisation process Completed';
}

Answer 1

try this:

<?php
while ($row = mysql_fetch_array($query)) {

    if ($row['index_no'] !== '456' && $row['lesson'] !== "Fertilisation process") { // this is redundant as  your query handles this
        echo '<a href="file:///D|/CC-Gate/localhost">Fertilisation process</a>';
    } else {
        echo 'Fertilisation process Completed';
    }
}