|
|
|
|
|
<<
Inapoi in pagina principala
Vanzari motociclete "0")) {echo $_GET["marca"];} else {echo "second hand";}?>
"0") and ($marca<>"")) $select.=' marca="'.$marca.'" ';
if ($model<>"") {if ($select=="") {$select.=' model LIKE "%'.$model.'%" ';} else {$select.=' AND model LIKE "%'.$model.'%" ';}}
if (($vechime<>"0") and ($vechime<>"")) {if ($select=="") {$select.=' an>=(YEAR(NOW())-'.$vechime.')';} else {$select.=' AND an>=(YEAR(NOW())-'.$vechime.')';}}
if (($categ<>"0") and ($categ<>"")) {if ($select=="") {$select.=' categ="'.$categ.'" ';} else {$select.=' AND categ="'.$categ.'" ';}}
if ($km<>"") {if ($select=="") {$select.=' km<="'.$km.'" ';} else {$select.=' AND km<="'.$km.'" ';}}
if (($puterea1<>"") and ($puterea2<>"")) {if ($select=="") {$select.=' puterea>="'.$puterea1.'" AND puterea<="'.$puterea2.'"';} else {$select.=' AND puterea>="'.$puterea1.'" AND puterea<="'.$puterea2.'"';}}
if (($cap1<>"") and ($cap2<>"")) {if ($select=="") {$select.=' capacitatea>="'.$cap1.'" AND capacitatea<="'.$cap2.'"';} else {$select.=' AND capacitatea>="'.$cap1.'" AND capacitatea<="'.$cap2.'"';}}
if (($culoarea<>"0") and ($culoarea<>"")) {if ($select=="") {$select.=' culoarea="'.$culoarea.'" ';} else {$select.=' AND culoarea="'.$culoarea.'" ';}}
if (($starea<>"0") and ($starea<>"")){if ($select=="") {$select.=' starea="'.$starea.'" ';} else {$select.=' AND starea="'.$starea.'" ';}}
if (($acte<>"0") and ($acte<>"")) {if ($select=="") {$select.=' acte="'.$acte.'" ';} else {$select.=' AND acte="'.$acte.'" ';}}
if (($pret1<>"") and ($pret2<>"")) {if ($select=="") {$select.=' pret>="'.$pret1.'" AND pret<="'.$pret2.'"';} else {$select.=' AND pret>="'.$pret1.'" AND pret<="'.$pret2.'"';}}
if (($judet<>"TOATE") and ($judet<>"")) {if ($select=="") {$select.=' judet="'.$judet.'" ';} else {$select.=' AND judet="'.$judet.'" ';}}
if ($_GET["user"]<>'') {
$q='select email from users where id='.$user;
//echo $q;
$row=mysql_fetch_array(mysql_query($q));
$email=$row[0];
$select.=' email="'.$email.'" ';
}
if ($select<>"") $select.=" AND ";
if ($sort=="pret") $ord='valid asc, pret asc';
else $ord='valid asc, dataora desc';
$q='select * from motovanzare where '.$select.' (valid=1 OR valid=2) order by '.$ord.' limit '.(($pag-1)*10).',10';
//echo $q;
$result=mysql_query($q);
while ($row=mysql_fetch_array($result))
{
?>
.html"> "") echo $row["poza1"]."_100.jpg"; else echo "../images/nophoto100.gif";?>" border="0" title=""> |
-
euro
ATENTIE ANUNT EXPIRAT |
|
Pagina:
'.$i.' ';
}
?>
|
|
|
|
|
|
|
|
|
|