EDIT* Sorry I didn't mean to add that error message in the topic title.
Hey guys, I'm new to PHP and MYSQL and I have been searching for hours for a way to copy the data from a row in one table (all columns) and insert it into another table (same column names). I've also browsed around Daniweb and haven't found a direct solution for my code. I'm sorry if this has already been posted here.
Here is some of my code
I connect to the first database, get the row and break down the columns into variables. I then close that connection and open another connection on another server and attempt to add those variables to the second database
$con1 = /*connect to server 1*/ $con2 = /*connect to server 2*/ mysql_select_db("database1", $con1) or die(mysql_error()); $result = mysql_query("SELECT * FROM table1 ORDER BY id DESC", $con1); $row1 = mysql_fetch_array($result); $row2 = mysql_fetch_array($result); $row3 = mysql_fetch_array($result); /*etc...*/ /*after finding the row, break it up*/ $one = $row3['col1']; $two = $row3['col2']; $three = $row3['col3']; /*etc...*/ mysql_close($con1); mysql_select_db("databse2", $con2) or die(mysql_error()); mysql_query (" INSERT INTO table2 (col1, col2, col3, col4, col5) VALUES('$one','$two','$three','$four','$five') ", $con2) or die(mysql_error());
I have an echo setup after the first connection, the second connection, and at the very end that echos all of the variables. They all work and I get no errors, but when I check the second database there is no data. I have tried countless ways of doing this, however, I always run into a problem or error. This is the closest I have gotten to completing the task at hand.
If anyone has some tips or advise, I would greatly appreciate the help. I've read hundreds of forums posts and gone through several options in the manual. maybe I missed something?