Изваждане на повече от един запис

Lenor

Registered
Здравейте. Вмомента ми изважда 1 запис, а искам да ми излизат 10 записа.

Код:
$masiv_stoinosti = array("");
$broi_elementi = count($masiv_stoinosti);
$broi_elementi = $broi_elementi - 1;
$random_chislo = rand(0 , $broi_elementi);
shuffle($masiv_stoinosti);
$simple_or_advanced = $masiv_stoinosti[$random_chislo];
$db = new MYSQL_DB();
$db->connect();
$db->select_db();
$db->set_names_utf_8();
$db->query="select count(*) as total from $simple_or_advanced";
$db->run_query();
$row = mysql_fetch_array($db->query_result);
$total = $row["total"];
$total = $total - 1;
$total_random = rand(0 , $total);

      

$db->query="select * from $simple_or_advanced limit $total_random , 1 ";
$db->run_query();
$row = mysql_fetch_array($db->query_result);



$id=$row["Zapis_ID"];
$available_or_not = $row["V_nalichnost"];
$kategoria = $row["Kategoriq"];
$marka = $row["Marka"];
$small_image = $row["Small_images"];
$first_image="";
if(strstr($small_image , "|"))
{
      $only_first_image = explode("|", $small_image );
      $first_image = $only_first_image[0];
}
else
{
      $first_image = $small_image;
}

       echo "<div class=\"item item-type-double\">";
        echo "<a class=\"item-hover\" href=\"osvetitelni_tela_view.php?id=$id\">";
             echo "<div class=\"item-info\">";            
                     echo "<div class=\"line\"></div>";                  
                     echo "<div class=\"headline\">Прегледай</div>";
                     echo "<div class=\"line\"></div>";
              echo "</div>";
              echo "<div class=\"mask\"></div>";
        echo "</a>";

        echo "<div class=\"item-img\"><img src=\"images/$first_image\" /></div>";
        echo "<div class=\"kategoria-promo\" align=\"center\">".$kategoria."</div>";      
       echo "</div>";        
 

Back
Горе