Home why the while loop runs once?
 the following code is only running once , while the number of times it should run is 4 , any help ? PHP:: prepare("SELECT name_ FROM projects")) { $stmt->execute();$stmt->bind_result($n); //$stmt->store_result(); $result =$stmt->get_result(); if($result->num_rows == 0) { echo "No Projects";$stmt->close(); $conn->close(); exit(); }else { while ($row = $result->fetch_assoc()) {$dirname = $dirname .$row["name_"] . "/"; $images = glob($dirname . "*.*", GLOB_BRACE); foreach($images as$image) { echo $row["name_"]; echo$result->num_rows; // returns 4 !!!! $image = base64_encode($image); //$arr[] =$image; array_push($arr,$image); $image = ""; } } echo json_encode($arr); // returns 1 json row oonly } } $stmt->close();$conn->close(); exit(); } ?>  num rows return 4 so why it runs or loops for one time only ? I am trying to get images from images folder to echo it back FIX:: according to jhilgeman's answer I added this part to the end of foreach: \$dirname = "images/main/";