include('config.php'); db_connect(); $Jour = date("d/"); $Mois = date("n/"); switch ($Mois) { case 1: $Mois = "01"; break; case 2: $Mois = "02"; break; case 3: $Mois = "03"; break; case 4: $Mois = "04"; break; case 5: $Mois = "05"; break; case 6: $Mois = "06"; break; case 7: $Mois = "07"; break; case 8: $Mois = "08"; break; case 9: $Mois = "09"; break; case 10: $Mois = "10"; break; case 11: $Mois = "11"; break; case 12: $Mois = "12"; break; } $Annee= date("/Y"); $quand1 = $Jour.$Mois.$Annee; // on met bout à bout $sql = mysql_query("SELECT * FROM maj WHERE id='1' "); $datee = mysql_result($sql,0,"date"); if($datee == "$quand1") { } else { $sql=mysql_query("select * from membres where vip > 0 "); $i=1; while($row=mysql_fetch_array($sql)) { $newvip=$row[vip]-1; $query = "UPDATE membres SET vip='$newvip' WHERE login = \"$row[login]\" "; $result = mysql_query($query); $query1 = "UPDATE maj SET date='$quand1' WHERE id = '1' "; $result1 = mysql_query($query1); } } session_start(); if(empty($_SESSION['login'])) { } else { $login = $_SESSION['login']; $result_sql = mysql_query("SELECT * FROM membres WHERE login=\"$login\" "); $ville = mysql_result($result_sql,0,"ville"); $pays = mysql_result($result_sql,0,"pays"); $mail = mysql_result($result_sql,0,"mail"); $vip = mysql_result($result_sql,0,"vip"); } ?>