$a2) { $info = "Le tournois finit avant qu'il commence? !"; include("modifier_tournoi.php"); } else if ($m>$m2 and $a<=$a2) { $info = "Le tournois finit avant qu'il commence? !"; include("modifier_tournoi.php"); } else if ($j>$j2 and $m<=$m2 and $a<=$a2) { $info = "Le tournois finit avant qu'il commence? !"; include("modifier_tournoi.php"); } else { include("conf.php"); include("mysql_compat.php"); include ("conf.php"); $db_connection=mysql_connect($db_host,$db_user,$password); mysql_select_db($db_name,$db_connection); $requete = calcul_requete_modif_table_tournoi(); $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); calcul_requete_modif_table_categorie(); //affichage du tableau de tournois include("modifier_tournoi.php"); } } function calcul_requete_modif_table_tournoi() { $date = date("Y"); $Club=$_GET['Club']; $Date_debut=$_GET['Date_debut']; $Date_fin=$_GET['Date_fin']; $Gain=$_GET['Gain']; $Juge=$_GET['Juge']; $Contact=$_GET['Contact']; $Mot_de_passe=$_GET['Mot_de_passe']; $id_tournoi=$_GET['Id_tournoi']; $requet= "UPDATE tournoi SET debut = '$Date_debut' ,fin = '$Date_fin' "; $requet=$requet.",club = '$Club',gains = '$Gain' ,juge_arbitre = '$Juge',engagement = '$Contact' ,mot_passe = '$Mot_de_passe',saison = '$date' WHERE id_tournoi = '$id_tournoi'"; return $requet; } function CategorieLibre($idtournoi,$ref_cat) { include("conf.php"); include("mysql_compat.php"); include ("conf.php"); $db_connection=mysql_connect($db_host,$db_user,$password); mysql_select_db($db_name,$db_connection); $requete= "SELECT id_categorie from categorie WHERE tournoi = '$idtournoi' and ref_cat = '$ref_cat' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $rep=mysql_fetch_array($reponse); $requete= "SELECT categorie from inscription WHERE categorie = '$rep[0]' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0') { $requete= "DELETE FROM categorie WHERE tournoi = '$idtournoi' and ref_cat = '$ref_cat' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } else { $info2 = "Impossible de supprimer la catégorie '$ref_cat' car des joueurs s'y sont inscrit"; echo $info2; } } function calcul_requete_modif_table_categorie() { $Categorie1=$_GET['categorie1']; $Categorie2=$_GET['categorie2']; $Categorie3=$_GET['categorie3']; $Categorie4=$_GET['categorie4']; $Categorie5=$_GET['categorie5']; $Categorie6=$_GET['categorie6']; $Categorie7=$_GET['categorie7']; $Categorie8=$_GET['categorie8']; $Categorie9=$_GET['categorie9']; $Categorie10=$_GET['categorie10']; $Categorie11=$_GET['categorie11']; $Categorie12=$_GET['categorie12']; $Categorie13=$_GET['categorie13']; $Categorie14=$_GET['categorie14']; $Categorie15=$_GET['categorie15']; $Categorie16=$_GET['categorie16']; $Categorie17=$_GET['categorie17']; $Categorie18=$_GET['categorie18']; $Categorie19=$_GET['categorie19']; $Categorie20=$_GET['categorie20']; $Categorie21=$_GET['categorie21']; $Categorie22=$_GET['categorie22']; $Categorie23=$_GET['categorie23']; $id_tournoi=$_GET['Id_tournoi']; include("conf.php"); include("mysql_compat.php"); include ("conf.php"); $db_connection=mysql_connect($db_host,$db_user,$password); mysql_select_db($db_name,$db_connection); $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '1' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie1)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','35','$id_tournoi','m','adulte','0','19','1')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie1)) { CategorieLibre($id_tournoi,1); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '2' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie2)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','40','$id_tournoi','m','adulte','0','19','2')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie2)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '2' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '3' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie3)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','45','$id_tournoi','m','adulte','0','19','3')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie3)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '3' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '4' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie4)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','999','$id_tournoi','m','adulte','0','19','4')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie4)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '4' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '5' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie5)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','35','$id_tournoi','f','adulte','0','19','5')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie5)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '5' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '6' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie6)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','40','$id_tournoi','f','adulte','0','19','6')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie6)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '6' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '7' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie7)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','45','$id_tournoi','f','adulte','0','19','7')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie7)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '7' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '8' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie8)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','999','$id_tournoi','f','adulte','0','19','8')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie8)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '8' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '9' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie9)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','8','$id_tournoi','m','jeune','0','19','9')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie9)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '9' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '10' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie10)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','10','$id_tournoi','m','jeune','0','19','10')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie10)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '10' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '11' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie11)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','12,'$id_tournoi','m','jeune','0','19','11')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie11)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '11' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '12' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie12)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','14','$id_tournoi','m','jeune','0','19','12')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie12)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '12' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '13' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie13)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','16','$id_tournoi','m','jeune','0','19','13')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie13)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '13' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '14' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie14)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','18','$id_tournoi','m','jeune','0','19','14')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie14)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '14' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '15' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie15)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','8','$id_tournoi','f','jeune','0','19','15')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie15)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '15' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '16' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie16)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','10','$id_tournoi','f','jeune','0','19','16')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie16)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '16' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '17' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie17)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','12','$id_tournoi','f','jeune','0','19','17')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie17)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '17' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '18' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie18)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','14','$id_tournoi','f','jeune','0','19','18')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie18)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '18' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '19' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie19)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','16','$id_tournoi','f','jeune','0','19','19')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie19)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '19' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '20' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie20)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','18','$id_tournoi','f','jeune','0','19','20')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie20)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '20' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '21' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie21)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','999','$id_tournoi','m','double','0','19','21')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie21)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '21' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '22' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie22)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','999','$id_tournoi','f','double','0','19','22')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie22)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '22' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } $requete= "SELECT * from categorie WHERE tournoi = '$id_tournoi' and ref_cat = '23' "; $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_num_rows($reponse); if ($reponse == '0' and !empty($Categorie23)) { $requete= "INSERT INTO categorie(id_categorie,age,tournoi,sexe,type,limite,avencement,ref_cat) VALUES ('','999','$id_tournoi','b','mixte','0','19','23')"; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } if ($reponse == '1' and empty($Categorie23)) { $requete= "DELETE FROM categorie WHERE tournoi = '$id_tournoi' and ref_cat = '23' "; mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } mysql_close($db_connection); } ?>