mysql_select_db($database_visiblePage, $visiblePage);
$TBName = "fpme_vPage2";
$query_miseajour = "SELECT * FROM ".$TBName;
$miseajour = mysql_query($query_miseajour, $visiblePage) or die(mysql_error());
$row_miseajour = mysql_fetch_assoc($miseajour);
$totalRows_miseajour = mysql_num_rows($miseajour);
do {
$query_tableStructureDescribe = "DESCRIBE ".$TBName;
$tableStructureDescribe = mysql_query($query_tableStructureDescribe, $visiblePage) or die(mysql_error());
$row_tableStructureDescribe = mysql_fetch_assoc($tableStructureDescribe);
$totalRows_tableStructureDescribe = mysql_num_rows($tableStructureDescribe);
do {
$nomField = $row_tableStructureDescribe['Field'];
if($row_miseajour[$nomField]== ""&& $nomField !=""){
$updatemaj = "UPDATE ".$TBName." SET `".$nomField."`=NULL WHERE `id`='".$row_miseajour["id"]."'";
mysql_select_db($database_visiblePage, $visiblePage);
$updatemajquery = mysql_query($updatemaj, $visiblePage) or die(mysql_error());
echo $updatemaj."<br>";
//echo "UPDATE".$row_miseajour["id"]." ".$nomField;
}
} while ($row_tableStructureDescribe = mysql_fetch_assoc($tableStructureDescribe));
} while ($row_miseajour = mysql_fetch_assoc($miseajour));