request error
this is my mysql query:
$requete1= " SELECT DISTINCT mariages.* FROM mariages, ";
$requete1.= " articles_a_offrir AS A1 INNER JOIN articles_a_offrir AS A2 ";
$requete1.= " ON (A1.id_mariage=A2.id_mariage) WHERE ";
$requete1.= " ((mariages.id_mariage=A1.id_mariage) ";
$requete1.= " AND (mariages.pren_epouse='$prenom_epouse') AND ";
$requete1.= "(mariages.nom_epouse='$nom_epouse')) ";
$requete1.= " OR ((mariages.nom_mari='$nom_mari') ";
$requete1.= " AND (mariages.pren_mari='$prenom_mari')) ";
$requete1.= " OR ((DAYOFMONTH(mariages.date_du_mariage)='$jour') ";
$requete1.= " AND (MONTH(mariages.date_du_mariage)='$mois') ";
$requete1.= " AND (YEAR(mariages.date_du_mariage)='$annee')); ";
but i would like it to display only one wedding even if the family name of somebody exists for two differnet people with a different first name
Subject
Written By
Posted
request error
March 30, 2005 06:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.