我有while循环从mysql,我尝试做一些事情的第一个结果下,如果否则做其他事情的第二个结果等....
my code this
$i = 1;
while($row = mysql_fetch_array($get_row)) {
$rowid = $row['rowid'];
$number = $row['number'];
$result = $number - 1;
if ($result != '0') {
// for only first result != 0 do this
require('result.php');
$i++;
// for all other results != 0 too do this
$edit_row = "UPDATE rows SET status = 'Ok' WHERE rowid = '$rowid'";
mysql_query($edit_row);
} elseif ($result == '0') {
$edit_row = "UPDATE rows SET status = 'Not Ok' WHERE rowid = '$rowid'";
mysql_query($edit_row);
}
}
只需增加$i
即可。当$i == 1
做其他时,做第一行。例子:
$i = 1;
while($row = mysql_fetch_array($get_row)) {
$rowid = $row['rowid'];
if ($i == 1) { //Do for first row when $i == 0
$i++; //Increase the value of $i
require('result.php');
$edit_row = "UPDATE rows SET status = 'Ok' WHERE rowid = '$rowid'";
mysql_query($edit_row);
} else { //Do other when $i > 1
$edit_row = "UPDATE rows SET status = 'Not Ok' WHERE rowid = '$rowid'";
mysql_query($edit_row);
}
}
还建议您使用mysqli
或PDO
代替mysql
。