i can't seem to find any official documents regarding mysqli's prepared statement having the ability to check whether there is another record from the statement.
is there a hidden equivalent function such as asp's hasNext function that wasn't documented?
that way..i could do something like this
while ($stmt->fetch(){
//prepares a html table only if users belong to different groups
//detect EOR
if(!$stmt->hasNext()){
//prepares the html table since it is the last record
}
}
or perhaps, the only way is to first count the rows with $mysqli->row_num and then keep checking in the loop until it reaches the count?