Search the Community

Hi: I made this code to try to get result on a database selection random on 3 different results. I want to get the result: ARTICLE1-ARTICLE2-ARTICLE3. Right now, I just have 1-1-1 How can I get this thing?? Thanks a lot for your help... <?php //--Dynamic module for 3 results // connection to database include ("conexion.php"); conecta(); //-- Consult database $sql="SELECT field1,field2,field3 FROM mytable ORDER BY RAND() Limit 3"; $result = mysql_query($sql) or die(mysql_error()); while ($fila=mysql_fetch_array($result)) { $one=$fila['field1']; $two=$fila['field2']; $three=$fila['field3']; echo"<tr>"; echo"<td align=center>"; echo"<P class=linea><strong>also this result:</strong></P>"; echo"<table border=0 width=630>"; echo"<tr>"; echo"<td align=center valign=top><a href=$two.html><img src=fotoarticulo/$three><br>"; echo"<P class=pequena><strong>one</strong></P></a></td>"; echo"<td align=center valign=top><a href=$two.html><img src=fotoarticulo/$three><br>"; echo"<P class=pequena><strong>$one</strong></P></a></td>"; echo"<td align=center valign=top><a href=$two><img src=fotoarticulo/$three><br>"; echo"<P class=pequena><strong>$one</strong></P></a></td>"; echo"</tr>"; echo"</table>"; echo"</td>"; echo"</tr>"; } //-- Close mysql_close(); ?> How can I made that my results are based on 3 random results from the database and printed in the table in order 1-2-3 (results)??? Please, help. Thanks. Regards