1) { $completare=" AND ("; $completareStiri=" AND ("; $completarePagini=" AND ("; $idx=0; foreach($keyword as $cuvant) { $string.=$cuvant." "; $completare.="(CONCAT_WS(' ',art_keyword, art_denumire, art_descriere) LIKE '%$cuvant%')"; $completareStiri.="(CONCAT_WS(' ',s_titlu, s_continut) LIKE '%$cuvant%')"; $completarePagini.="(CONCAT_WS(' ',s.s_titlu, s.s_keyword, s.s_descriere, sd.bd_text) LIKE '%$cuvant%')"; if ($idx!=count($keyword)-1) { $completare.=" AND "; $completareStiri.=" AND "; $completarePagini.=" AND "; } $idx++; } $completare.=")"; $completareStiri.=")"; $completarePagini.=")"; $string=substr($string,0,-1); $sqlPagini="SELECT * FROM t_static_detalii AS sd INNER JOIN t_static AS s ON s.s_id=sd.bd_b_id WHERE 1=1 $completarePagini GROUP BY s.s_id"; $sqlProiecte="SELECT * FROM t_articole WHERE 1=1 $completare"; $sqlStiri="SELECT * FROM t_stiri WHERE 1=1 $completareStiri"; } else { $string=$keyword[0]; $sqlPagini="SELECT * FROM t_static_detalii AS sd INNER JOIN t_static AS s ON s.s_id=sd.bd_b_id WHERE CONCAT_WS(' ',s.s_titlu, s.s_keyword, s.s_descriere, sd.bd_text) LIKE '%$string%' GROUP BY s.s_id"; $sqlProiecte="SELECT * FROM t_articole WHERE CONCAT_WS(' ',art_keyword, art_denumire, art_descriere) LIKE '%$string%'"; $sqlStiri="SELECT * FROM t_stiri WHERE CONCAT_WS(' ',s_titlu, s_continut) LIKE '%$string%'"; } ?>

0) { while($rowPagini=fetch($resPagini)) { $descriere=$rowPagini['s_descriere']; if($rowPagini['s_descriere']=="") { $detaliiRes=query("SELECT * FROM t_static_detalii WHERE bd_b_id='".$rowPagini['s_id']."' AND bd_tip='1' LIMIT 0,1"); $detaliiRow=fetch($detaliiRes); $descriere=$detaliiRow['bd_text']; } ?>

0) { ?>