16 lines
389 B
PHP
16 lines
389 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$query = "select * from user_account where transaction_datetime < '1900-01-01'";
|
|
$results = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$etime = date("Y-m-d H:i:s", $row['entered_time']);
|
|
$rnum = $row['record_num'];
|
|
db_query("UPDATE user_account SET transaction_datetime = '$etime' WHERE record_num = $rnum");
|
|
echo("$etime\n");
|
|
}
|
|
|
|
?>
|