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

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


[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]

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]