如何在mysqli_query结果对象中返回一条记录[关闭]

Question

I know mysqli_data_seek let us move at the desired offset, but how can I use it to go just one step back when a specific criteria met? I am using while-loop for the condition so you can conclude that when the condition will be met the pointer will be on next record. How can I pull it back just one step?

Answer 1

Try this:

$i = 0;
while($row = mysqli_fetch_row($result)){
 if($i != 0 && condition){
       mysqli_data_seek($result, $i-1);
 }
$i++;
}