$o=12; include'meniu.php'; ?>
Harti disponibile:
Id
Nume
Categoria
Foto
ISBN
Limba
Data
Marimea
Prezentare
Marca
Scara
Pret
cant.
ad.
pret $timp=time(); $sql ='select p.*, o.default, m.nume as mnume'; $sql.=', c2.nume as c2nume, c3.nume as c3nume'; $sql.=', prez.nume as preznume'; //$sql.=', vrnt.nume as varnume'; $sql.=', gr.nume as grnume'; $sql.=' from'; if( bad($c,0,1)) //harti asociate die('bad code!'); $sql.=" $crtbd.oferta as o"; $sql.=' left join shop2.produse as p on o.prod=p.id'; // $sql.=' left join furnizori as f on furnizor=f.id'; $sql.=' left join shop2.marca as m on marca=m.id'; // $sql.=' left join '; $sql.=' left join shop2.caracteristici as c2 on c2=c2.id'; $sql.=' left join shop2.caracteristici as c3 on c3=c3.id'; $sql.=' left join shop2.caracteristici as prez on prezentare=prez.id'; // $sql.=' left join shop2.caracteristici as vrnt on varianta=vrnt.id'; $sql.=' left join shop2.grupe as gr on p.grup=gr.id'; $sql.=" where o.cmap=$c"; $sql.=" and !disable and valabil>$timp"; // $dbg=2; $rez=sql($sql,'shop2'); $i=0; $sum=0; while( $lin=mysql_fetch_array($rez) ) { echo'
{$lin['idf']}
\n"; echo"
{$lin['nume']}
{$lin['grnume']}
\n"; echo'
'; echo'
'; echo"{$lin['c1']}
\n";//isbn echo'
'; echo"{$lin['c2nume']}
\n"; echo'
'; echo"{$lin['data']}
\n"; echo'
'; echo"{$lin['c3nume']}
\n"; echo'
'; echo"{$lin['preznume']}
\n"; echo'
'; echo"{$lin['mnume']}
\n"; echo'
1:'.number_format($lin['v1'],0,',',' '); echo'
'; ; switch( $pr=$lin['pret'] ) { case 1: $pr*=$usd; break; case 2: $pr*=$eur; break; } echo number_format($pr,$zec,',',' '); echo'
0 );\n"; echo " enb[$i]=(this.value>0);\n"; echo " ctotal(this.value,$i);\n"; echo '">
\n"; echo'
'; echo'
'; echo"\n"; $i++; } ?>
Total: