PHP|Débutant :: Forums

$sql1 = "SELECT id_info FROM info1_bdc_tag T WHERE T.mot_cle = '$tag' ";
$req1 = mysql_query($sql1) or die('Erreur SQL 1 : <br />'.$sql1.'<br>'.mysql_error());
$first = true;
while($data = mysql_fetch_assoc($req1)){  
  if ($first == true){
    $liste_id .= $data['id_info'];
  } else {
    $liste_id .= ",".$data['id_info'];  
  }
  $first = false;
}

$sql = "SELECT I.*, C.nom_cat, S.nom_sous_cat FROM info1_bdc_info I
          LEFT JOIN info1_bdc_cat C ON C.id_cat = I.categorie
          LEFT JOIN info1_bdc_sous_cat S ON S.id_sous_cat = I.sous_categorie    
          WHERE valide='1' AND id IN ($liste_id) ORDER BY rate DESC ";    
  $req = mysql_query($sql) or die('Erreur SQL 1 : <br />'.$sql.'<br>'.mysql_error());