0x1998 - MANAGER
Edit File: new1.php
<?php $link = mysqli_connect('ga804575-001.dbaas.ovh.net', 'u_db_elearning','zGkd6C53T','elearning',35451); $result=mysqli_query($link, "select id from j25_users A where A.lastvisitDate='0000-00-00 00:00:00'"); while ($row=mysqli_fetch_array($result)) { echo $row['id']."<br/>"; mysqli_query($link, "update j25_users set lastvisitDate='2040-01-01 00:00:00' where id=".$row['id']) or die ('erreur'); } /* Ensuite modifier la structure de la table j25_users en rendant lastvisitDate null puis passer ce script update j25_users B set B.lastvisitDate=null where B.lastvisitDate='2040-01-01 00:00:00' */ ?>