Advertisement
Guest User

Untitled

a guest
Jul 13th, 2014
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. <?PHP
  2. //.. your codes like connection & ...
  3. // my_table is your table name.
  4. $query = mysql_query("SELECT * FROM my_table");
  5. $stored = array();
  6. $i = 0;
  7. while($row = mysql_fetch_assoc($query))
  8. {
  9. $stored[++$i] = date('Y-m-d H:i:s', $row["start_date"]);
  10. }
  11. mysql_query("alter table my_table modify start_date DATETIME;");
  12. $query = mysql_query("SELECT * FROM my_table");
  13. $i = 0;
  14. while($row = mysql_fetch_assoc($query))
  15. {
  16. // Id is your primary key.
  17. mysql_query("UPDATE my_table SET start_date='" . $stored[++$i] . "' WHERE id='" . $row['id'] . "'")
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement