Php And Mysql Rand

[luismc2007]

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

[AyKay47]

Can you post your db table structure. I also don't quite understand your issue.