php/query - moving data

[Natch]

Originally Posted by Reeve of shinra

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);
} 


You have quote marks around your fieldnames ... try this...[SQL]INSERT INTO journals (journal_id,journalist_id,entrycount,journalviews, active,lastentrydate)
VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')[/SQL]