You'll have to excuse my weak php knowledge. My understanding is that the while loop is ok for a list of rows for example. Ford MustangChevy CorvettePontiac Firebird However, I need to echo one of the 3 rows separately and uniquely in various parts of the page. Usually I echo a single result like so with the RAND LIMIT set to 1; Row 1 = Ford Mustang
<h1>More <?php echo $row_rs['results'];?>Ford Mustang</h1>
However, now I have 3 in the RAND LIMIT I have 3 rows. e.g. Row1 = Ford MustangRow2 = Chevy CorvetteRow3 = Pontiac Firebird Now I need to put a result for whichever row I decide into differing parts of the page. (The <?php echo $row_rs['Row n'];?> part is for example purposes only.)
<h1>Car: <?php echo $row_rs['Row1'];?>Ford Mustang</h1>
html...
<p>Car: <?php echo $row_rs['Row3'];?>Pontiac Firebird</p>
more html...
<h3>Car: <?php echo $row_rs['Row2'];?>Chevy Corvette</h3>
So somehow I think I need to put row 1, 2 and 3 into an array so that I can call them separately and uniquely. I hope that makes sense.