while($rows[] = mysqli_fetch_assoc($result));
array_pop($rows);  // pop the last row off, which is an empty row

Here is the correct way to turn your mysql results into an array.  Forget the other nonsense of useless code.  Why type out this long code: "for($i = 0; $array[$i] = mysqli_fetch_assoc($result); $i++) ;"  when you can accomplish the same thing with much less code.

Turn MySQL results into an array, the proper way!

mysql, php

PHP