Storing iterated results into various variables

May be some one could help me here, I am trying to retrieve results from a table that gives 9 rows, from each row I am trying to pull out two fields and assign the two values of those column fields to a variable $image1 and $caption1, and now I want to go to the next row and pick up the values of the corresponding fields and store it in the next variable $image2 and $caption2 and to continue until I reach 9 rows. The reason for this technique is I am trying to inject the dynamic data inside a page which is already formatted with HTMLs (kind of template) and by means of Php tags I can echo these variables where needed. Thanks for your time and help in advance I'd appreciate it. GD