include('connect.php'); include('func.php'); $title='Anunturi campus - Onlinestudent'; include('top.php'); $sql_stiri_pag = "select distinct anunturi_campus.titlu, username,anunturi_campus.id,anunturi_campus.date_contact,categ_anunturi_campus.nume,anunturi_campus.descriere,anunturi_campus.data_postare,anunturi_campus.valabilitate,orase.denumire from anunturi_campus LEFT JOIN categ_anunturi_campus ON anunturi_campus.categorie=categ_anunturi_campus.id_categ LEFT JOIN users ON anunturi_campus.user=users.id LEFT JOIN orase ON anunturi_campus.oras=orase.id_oras group by anunturi_campus.titlu order by id desc "; $paginare=paginare2("page", $sql_stiri_pag, $abs_path.PATTERN, true,10); if(!is_numeric($_GET["page"]) or empty($_GET["page"])) $_GET["page"]=1; $pagina=$_GET["page"]; $sql_stiri = $sql_stiri_pag; $afis=10; $sql_stiri.= " LIMIT ".$select_limita_inferioara.", ".$afis; $res_stiri = mysql_query($sql_stiri) or die(mysql_error()); $i=0; ?>