"; echo "
"; $connect = mysql_connect("localhost","userparcpilotes","golgoths") or die ("erreur de connexion"); mysql_select_db('mysqlparcpilotes',$connect) or die ("erreur de connexion base"); $query= mysql_query("SELECT * FROM annonces ORDER BY id_annonce DESC LIMIT 6000,90"); while($code = mysql_fetch_object($query)) { $id = ($code->Id_annonce); $titre = stripslashes($code->Titre_annonce); $titre_url = strtr( strtr($titre, '?$,&:()!{}."_#=/\\;', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy---------------------'), array('' => 'TH', '' => 'th', '' => 'DH', '' => 'dh', '@'=>'-at-', '' => 'ss', '' => 'OE', '' => 'oe', '' => 'AE', '' => 'ae', '' => 'u', '+' => '-' ) ); $titre_url = preg_replace('|[^A-Z0-9-]|i', '-', $titre_url); $titre_url = preg_replace('|[\-]+|i', '-', $titre_url); $titre_url = preg_replace('|-$|i', '', $titre_url); $titre_url = strtolower($titre_url); $temp = ""; If ($code->Categorie_Annonce == "Crosscar") { $temp = ("kartcross"); } If ($code->Categorie_Annonce == "Autocross") { $temp = ("Autocross"); } If ($code->Categorie_Annonce == "Rallye") { $temp = ("Rallye"); } If ($code->Categorie_Annonce == "RallyeTT") { $temp = ("RallyeTT"); } If ($code->Categorie_Annonce == "Cote") { $temp = ("Cote"); } If ($code->Categorie_Annonce == "Karting") { $temp = ("Karting"); } If ($code->Categorie_Annonce == "Quad") { $temp = ("Quad"); } If ($code->Categorie_Annonce == "Transport") { $temp = ("Transport"); } If ($code->Categorie_Annonce == "Equipement") { $temp = ("Equipement"); } If ($code->Categorie_Annonce == "Divers") { $temp = ("Divers"); } $temp = ($temp."-"); $temp = ($temp.$titre_url); $temp = ($temp."-id-"); $temp = ($temp.$code->Id_annonce); $temp = ($temp.".html"); $temp = ("http://www.parc-pilotes.com/fr/".$temp); $Datefr = ($code->Date_Annonce); ?> "; } mysql_close(); ?>