1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
function get_name($arg1,$arg2,$cp) {
$sql = "SELECT peoId,peLastName,peFirstName,date_de_naissance FROM ".table(2)." WHERE ";
if(isset($arg1))
$sql .= " peLastName LIKE '".$arg1."%' ";
if(isset($arg1) && isset($arg2))
$sql .= " AND ";
if(isset($arg2))
$sql .= " peFirstName LIKE '".$arg2."%' ";
$sql .= " ORDER BY ".$cp." ASC LIMIT 0,20 ";
$query = mysql_query($sql);
$total = mysql_num_rows($query);
echo "<ul>";
if($total==0)
echo "<li onClick='createPeople()'>Créer</li>";
else {
switch($cp) {
case "peLastName" :
while($tab = mysql_fetch_array($query)) {
sql="peLastName FROM ".table(2)."
WHERE peLastName='".$tab["peLastName"]."' AND peFirstName='".$tab["peFirstName"]."' ";
$req_doublons=mysql_query($sql);
$date_naissance=(mysql_num_rows($req_doublons)>1)?" ".$tab["date_de_naissance"]:"";
echo "<li onClick='afficher_credit(".$tab['peoId'].")'>".$tab["peLastName"]." ".$tab["peFirstName"].$date_naissance."</li>";
}
break;
case "peFirstName": while($tab = mysql_fetch_array($query)) {
sql="peLastName FROM ".table(2)."
WHERE peLastName='".$tab["peLastName"]."' AND peFirstName='".$tab["peFirstName"]."' ";
GROUP BY peLastName,peFirstName";
$req_doublons=mysql_query($sql);
$date_naissance=(mysql_num_rows($req_doublons)>1)?" ".$tab["date_de_naissance"]:"";
echo "<li onClick='afficher_credit(".$tab['peoId'].")'>".$tab["peFirstName"]." ".$tab["peLastName"].$date_naissance."</li>";
}
break;
}
} |
Partager