MySQL Forums
Forum List  »  Newbie

request error
Posted by: alfred hitchcock
Date: March 30, 2005 06:38AM

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

Options: ReplyQuote


Subject
Written By
Posted
request error
March 30, 2005 06:38AM
March 30, 2005 06:39AM


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.