title: Store MySQL results in seperate PHP variables
body: <p>I have a MySQL query that returns 3 random rows whenever it is ran. I want to store each row in an array, with each column of the row a different part of the array. Hopefully Im being clear. Here is where Im at so far.</p>
  
  <pre><code>$result = mysql_query("SELECT NAME,AUTHOR,CITY FROM TESTIMONIALS ORDER BY RAND() LIMIT 3");
  $row = mysql_fetch_array($result);
  </code></pre>
  
  <p>The problem with this is it stores EVERYTHING in $result, and I do not know how to reference different columns once it is there. I'm doing this so I can ultimately print the specified random entries that I would like into 9 different DIVs.</p>