php/query - moving data

[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



$q = $DB_site->query("SELECT * FROM old_journal");

while($x = mysql_fetch_array($q)) {

$t = "INSERT INTO journals ('journal_id','journalist_id','entrycount','journa lviews','active','lastentrydate')
VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')";

mysql_query($t);
}

[Natch]

Take a look at the facilities provided by INSERT ... SELECT

[DJ RRebel]

Did you notice the following typo (extra space)? lol ... I hate making typos like that ... you never notice them until the very last thing ... lol ... like looking everywhere for your keys, only to find them in the last pocket !!! lol

'lastentrydat e'

[Natch]

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



$q = $DB_site->query("SELECT * FROM old_journal");

while($x = mysql_fetch_array($q)) {

$t = "INSERT INTO journals ('journal_id','journalist_id','entrycount','journa lviews','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...INSERT INTO journals (journal_id,journalist_id,entrycount,journalviews, active,lastentrydate)
VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')