for($x=0; $x<$sth->rows; $x++) {
    $data = $sth->fetch_hashref;

    $this = $data->{id};
    $prev = ...
}