 <p>Use the while statement:</p> <pre><code>while($row = $result-&gt;fetch_assoc()) { echo "First name:" . $row['fname']; echo " last name:" . $row['lname']; echo " Email:" . $row['email']; echo " Website:" . $row['website']; echo " comment:" . $row['comment']; } </code></pre>