title: How to select multiple rows from mysql with one query and use them in php
body: <p>I currently have a database like the picture below. </p>
  
  <p><img src="https://i.stack.imgur.com/TEnQj.png" alt="enter image description here"></p>
  
  <p>Where there is a query that selects the rows with number1 equaling 1. When using </p>
  
  <pre><code>mysql_fetch_assoc()
  </code></pre>
  
  <p>in php I am only given the first is there any way to get the second? Like through a dimesional array like </p>
  
  <pre><code>array['number2'][2] 
  </code></pre>
  
  <p>or something similar</p>