Náhodné řazení výledků

$dbc = mysql_connect (DB_HOSTITEL, DB_UZIVATEL, DB_HESLO);
mysql_select_db (DB_NAZEVDATABAZE);

$dotaz = "SELECT CONCAT(jmenofirmy) AS jmenofirmy, CONCAT(popis) As popis, CONCAT(foto1) As foto1, CONCAT(id) As id FROM pm_properties WHERE popis LIKE '%$nalezeno%' ORDER BY varianta DESC";

$vysledek = @mysql_query ($dotaz, $dbc); // Spus?te dotaz.
if ($vysledek) { // Je-li vše OK, zobrazit uživatele.

$num=mysql_num_rows($vysledek);   
//$ctrl je pomocná premenná   
if ($ctrl<>1)    
{   
    $strana=1;   
}//endif   

$limit=12;   
$celkovy_pocet=$num;   
$pocet_stran=ceil($celkovy_pocet/$limit);   
$pociatok=($strana*$limit)-$limit;   
 

for ($i=1; $i<=$pocet_stran; $i++)   
{   
    if ($i<>$strana)    
    {?>
                <a href="databaze.php?ctrl=1&strana=<?php echo $i; ?>&nalezeno=<?php echo $nalezeno; ?>"><?php echo $i; ?></a> |
                <?php }   
    else    
    {   
        echo "<font color=\"#FF0000\">",$i,"</font> | ";   
    }//endif   
}//endfor   
  
if ($strana<>$pocet_stran)   
{ ?>
                <a href="databaze.php?ctrl=1&strana=<? echo $strana+1; ?>&nalezeno=<? echo $nalezeno; ?>">nasledující strana</a>
                <?php }//endif   
echo "</p>";  

echo '<table align="center" cellspacing="2" cellpadding="2">';
  
$dotaz2 = "SELECT CONCAT(foto1) AS foto1, CONCAT(jmenofirmy) AS jmenofirmy, CONCAT(popis) As popis, CONCAT(id) As id FROM pm_properties WHERE vmesto like '%$mesto%' AND vkraj like '%$kraj%' AND aktivity like '%$aktivity%' ORDER BY varianta ASC, RAND() LIMIT $pociatok, $limit";
 
$vysledek2 = @mysql_query ($dotaz2); // Spus?te dotaz.
	
if ($vysledek2) { // Je-li v&scaron;e OK, zobrazit uživatele.

  

echo '<table align="center" cellspacing="2" cellpadding="2">';
  
while ($radek = mysql_fetch_array($vyslednik, MYSQL_NUM)) {

echo "<tr><td align=\"left\" width=\"60\" valign=\"top\"><img src=\"photos/{$radek[0]}\" border=\"0\" height=\"50\" width=\"55\"></td><td width=\"500\" align=\"left\"><b><font size=\"-1\" face=\"Arial, Helvetica, sans-serif\" color=\"#FF6600\"><a href=\"
vizitka.php?id={$radek[3]}\">$radek[1]</a></font></b><br>$radek[2]<br /><hr><br />
</td><td align=\"right\" width=\"50\"><a href=\" vizitka.php?id={$radek[3]}\" ><img src=\"images/vice.jpg\" hspace=\"5\" border=\"0\">Více</a></td></tr>\n";
  }

  echo '</table>';
  
  mysql_free_result ($vysledek2); 

     
   }
  }



mysql_close();