Store MySQL results in seperate PHP variables

ruspa

New Member
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.\[code\]$result = mysql_query("SELECT NAME,AUTHOR,CITY FROM TESTIMONIALS ORDER BY RAND() LIMIT 3");$row = mysql_fetch_array($result);\[/code\]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.
 
Back
Top