insert to table

putraaridana

hi i have this code
all i want to do is insert two fields from table_1 to table_2
both have the same field type just those two field (code and country)

help !
<?php
mysql_connect("localhost", "user", "pass") or die("could not connect");
mysql_select_db("mydb_1");

$result = mysql_query("SELECT countries_id, countries_name FROM table_1");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

    mysql_connect("localhost", "user", "pwd") or die("could not connect");
	mysql_select_db("mydb_2");

	$result_1 = mysql_query("insert into table_2 values "$row["code"],$row["country"]"");

}

mysql_free_result($result);

thanks

rachel2004

Are these two separate databases or just two tables in the same database? From your problem's description, it sounded like they were two tables in the same db. From your code, though, you have one table in one database and you have a second table in the second database.

Anyway, here is my best guess at what you were trying to do. Notice my use of mysql_pconnect() There's no error checking and I didn't test it as I'm too lazy to build a second database on my server just to try it at this moment:

<?php
mysql_pconnect("localhost", "user", "pass") or die("could not connect");
mysql_select_db("mydb_1");

$result = mysql_query("SELECT countries_id, countries_name FROM table_1");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$c_id = $row['countries_id'];
$c_name $row['countries_name'];

mysql_connect("localhost", "user", "pwd") or die("could not connect");
mysql_select_db("mydb_2");

$insert = "INSERT INTO table_2
           VALUES
           ('$c_id', '$c_name')";

$result_1 = mysql_query($insert)
    or die("Couldn't perform INSERT statement: ".mysql_error());
}
?>

putraaridana

thanks
i it's work but from 250 data from table_1 in mydb1 only insert
50 to the table_ in mydb_2
and i got this error

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ivoire')' at line 3"

i confiouse me, first insert then couldn't
thanks again

mourisj

I guess, as you are working on countries, that you have "Côte d'Ivoire" in your table! Notice that there is a quote (') in the name. This one terminates your string at "Côte d", and the rest of your string is not valid SQL syntax anymore.

Try to use double-quotes in ("$c_id", "$c_name"); not sure if this works; otherwise, there are way to escape these characters, but at this moment, I don't know how to do this, and I currently have no doc available.

HTH

JJ Mouris

mourisj

HTH

JJ Mouris

mourisj

INSERT INTO table_2 VALUES (50, 'Côte d'Ivoire');

Try to use double-quotes in ("$c_id", "$c_name"); not sure if this works; otherwise, there are ways to escape these characters, but at this moment, I don't know how to do this, and I currently have no doc available.

HTH

JJ Mouris