document.location.href='".$global."';"; }*/ include('../../connection/connect.php'); include('../../functions/url_rewriting.php'); include('../../functions/get_french_date.php'); include('../../login/visit.php'); $menu_top=2; // J'ai le même objet à troquer if (!empty($_GET['idf'])){ $result_from = mysql_query("SELECT titre, new_numsousrubrique, prix, annee from annonces WHERE numeroauto = '".$_GET['idf']."' "); if(mysql_num_rows($result_from) != 0 ){ $rs_from = mysql_fetch_object($result_from); $_POST['titre'] = $rs_from ->titre ; $_POST['choix_rub'] = $rs_from ->new_numsousrubrique ; $_POST['valeur'] = $rs_from ->prix ; $_POST['annee'] = $rs_from -> annee; } } /********************************************************************************************** **********************************************************************************************/ $query_rubrique = "SELECT distinct(r.libellerub) as libellerub ,sr.libellesousrub as sousrubrique, sr.numrubrique, sr.numsousrub, (sr.numsousrub = 1) as tutur "; $query_rubrique .=" FROM rub r inner join sousrub sr on r.id= sr.numrubrique "; $query_rubrique .=" order by r.id ASC, tutur DESC, libellesousrub ASC"; $resul_rubrique = mysql_query($query_rubrique) ; $liste_rub = " \n "; mysql_free_result($resul_rubrique); /********************************************************************************************** < FIN DES RUBRIQUES > **********************************************************************************************/ ?>