|
// connexion avec la base
$db_type = "mysql";
$db_user = "analogde";
$db_pass = "rainbow";
$db_name = "analogde";
$db_host = "sql2";
// authentification et connexion
$connexion = mysql_connect($db_host,$db_user,$db_pass);
if(!$connexion)
{ echo "Désolé, y a un bléme, connexion au serveur $db_host impossible\n";
exit;
}
// pointe sur la base
$db = mysql_select_db($db_name,$connexion);
if(!$db)
{ echo "Désolé accés a la base $db_name impossible\n";
}
switch($action)
{
case 'g' :$result = MYSQL_QUERY("select * from powerball order by main_gauche desc"); break;
case 'd' :$result = MYSQL_QUERY("select * from powerball order by main_droite desc"); break;
case 'e' :$result = MYSQL_QUERY("select * from powerball order by endurance desc"); break;
default :$result = MYSQL_QUERY("select * from powerball order by main_droite desc");
}
/*if($action == 'g')
{ $result = MYSQL_QUERY("select * from powerball order by main_gauche desc");
}
if($action == 'd')
{
$result = MYSQL_QUERY("select * from powerball order by main_droite desc");
}
if($action == 'e')
{ $result = MYSQL_QUERY("select * from powerball order by endurance desc");
}
if ($action != 'g' || $action != 'd' || $action != 'e')
{
echo " classement de base";
// recherche le nombre total d'entrée dans la base
$result = MYSQL_QUERY("select * from powerball order by main_gauche desc");
} */
$number = MYSQL_NUM_ROWS($result);
// affiche le nombre d'entrée dans la base
echo " $number enregistrements. "; $i=0; // entête du tableau echo "
Ajouter un enregistrement "; // referme la connexion avec la base de donnée mysql_close(); ?> |
|||||||||||||||||