I am trying to copy some the info in some fields in one table to blank fields in another table. Does this code look right to you? It doesnt seem to doing the trick.
Thanks
PHP Code:
$q = $DB_site->query("SELECT * FROM old_journal");
while($x = mysql_fetch_array($q)) {
$t = "INSERT INTO journals ('journal_id','journalist_id','entrycount','journalviews','active','lastentrydate')
VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')";
mysql_query($t);
}