Exemple d'utilisation avec MySQL

...
 mysql_connect($hostname, $username, $password) or die("Connexion impossible");
 @mysql_select_db("$dbName") or die("Impossible d'accèder à la base $dbName");
 
 $query = "SELECT * FROM $usertable WHERE (annee LIKE 'ESSI3');
 $result = mysql_query($query);
 
 $number = mysql_numrows($result);
 
 i = 0;
 if ($number == 0) {
     print "<CENTER><P>Il n'y a aucun élève en ESSI3!</CENTER>";
 elseif ($number > 0) {
     $nom = mysql_result($result, $i, "nom");
     $email = mysql_result($result, $i, "email");

    print "Nom = $nom, email = $email<BR>";
     i++;
 }
 ...