sql_query("SELECT * FROM mag_produse WHERE peindex>0 AND activ='Y' ORDER BY peindex");
$sfarsit=$dbs_index->num_rows();
$i=0;
$o=0;
while($produs = $dbs_index->fetch_array())
{
$topcomenzi=new sql();
$topcomenzi->sql_query("SELECT SUM(cantitate) as sumapc FROM mag_comenzi_detalii WHERE id_produs='".$produs['id']."'");
$suma=$topcomenzi->fetch_array();
$data_produse[]=array('id' => $produs['id'],'pret' => $functie->calculeaza_pret_produs($produs['id']),'comenzi' => $suma['sumapc']);
$idurile_produs[$o]=$produs['id'];
$pretul_produs[$o]=$functie->calculeaza_pret_produs($produs['id']);
$titlu.=$produs['nume'].',';
$m_keywords.=$produs['nume'].',';
$m_descriere.=$produs['nume'].',';
$comenzi[$o]=$suma['sumapc'];
$topcomenzi->close();
$o++;
}
$dbs_index->close();
$homepage->SetTitle($titlu);
$homepage->SetKeywords($m_keywords);
$homepage->SetM_descriere($m_descriere);
$homepage -> Display();
//DELOGARE UTILIZATORI//
if($_GET['cmd']=='logout' && $_SESSION['id_client_mag'] && $_SESSION['prenume'] && $_SESSION['email'])
{
session_unset();
session_destroy();
echo'
';
}
//SFARSIT DELOGARE UTILIZATORI//
//=======================BANNER==================
echo '';
$functie->poza("swf/proBannerFix",590,230,0,"ProBanner","","","","");
echo '
';
//=======================SFARSIT BANNER==================
$homepage->DisplayHeader_sub_cautare();
//=======================BARA SORTARE PRODUSE SI PAGINI==============
echo '
|
'.$txt_in_produse_promovate.'
|
|
';
//=======================SFARSIT BARA SORTARE PRODUSE SI PAGINI======
//=======================PRODUSE PROMOVATE==================
echo '
';
if(!$sfarsit)
{
$homepage -> mesajFormular("formularAtentie",$txt_in_nu_exista);
}
else
{
echo'
DisplayProduse($i,$o,$idurile_produs,$pretul_produs,$comenzi);
//=======================SFARSIT PRODUSE PROMOVATE==================
echo '> ';
}
echo'
|
';
$homepage -> DisplayFooter();
//$dbs_categ_specs->close();
?>