1 2 3 4 5 6 7 8 9 10 11 12 13
| <?php
$host = "localhost:3307";
$username = "root";
$password = "admin";
$db = "db_recus";
$my = mysql_connect($host,$username,$password);
mysql_select_db($db,$my);
$cin = $_GET['cin'];
$requete = "SELECT (SELECT num_client FROM client WHERE cin='".$cin."') as 'num_clt', (SELECT nom FROM client WHERE cin='".$cin."') as 'nom', (SELECT prenom FROM client WHERE cin='".$cin."') as 'prenom', max(num_client) as 'max_clt' FROM client" ;
$resultat = mysql_query($requete) ;
$data = mysql_fetch_assoc($resultat) ; // c'est le tableau que je souhaite récupérer dans l'autre page.
?> |
Partager