title: How can I get and display all values of a certain field in a sql table?
body: <p>I have a table wherein I need to get all the data in one column/field, but I can't seem to make it work with the code I have below:</p>
  
  <pre><code>$con=mysqli_connect("localhost","root","","database");
  $result = mysqli_query($con,"select * from client");
  $row = mysqli_fetch_array($result111);
  echo $row['name'];
  </code></pre>
  
  <p>With the code above, it only prints one statement, which happens to be the first value in the table. I have 11 more data in the table and they are not printed with this.</p>