Hi!
I just recently redesigned my database. Actually, I created a new one from scratch, say called db2. Now I would like to copy selected data from tables in the 'db1' to the new tables in the 'db2'. I tried to open 2 db connections, select all data from the first db tables, then a normal
while($data=fetcharray($oldhandle)), with and msql_query(insert into table_in_db2 values old_columns, $newdbhandle)
but it just does absolutely nothing. It doesn't give an error, it gives no result and it adds nothing to the 'db2' table. I checked with phpinfo(), and i have unlimited mysql connections aviable. why doesn't it work ?
and advice would be greatyl appreciated!
mats99
I just recently redesigned my database. Actually, I created a new one from scratch, say called db2. Now I would like to copy selected data from tables in the 'db1' to the new tables in the 'db2'. I tried to open 2 db connections, select all data from the first db tables, then a normal
while($data=fetcharray($oldhandle)), with and msql_query(insert into table_in_db2 values old_columns, $newdbhandle)
but it just does absolutely nothing. It doesn't give an error, it gives no result and it adds nothing to the 'db2' table. I checked with phpinfo(), and i have unlimited mysql connections aviable. why doesn't it work ?
and advice would be greatyl appreciated!
mats99