if( $result = $mysqli->query($sql) ){
echo ' the number of the result is '.mysqli_num_rows($result)."<br>";
while ($row = $result->fetch_row()) {
printf ("%s/n", $row[0]);
}
}
if( $result = $mysqli->query($sql) ){
echo ' the number of the result is '.mysqli_num_rows($result)."<br>";
while ($row = $result->fetch_row()) {
printf ("%s/n", $row[0]);
}
}