$num_rows = mysqli_num_rows($result); code example Example: php mysqli number row mysqli_num_rows($result);