export and input multiple entries via php

v3nt

need to copy across a few hundred entries from a field on one table to another field on another table.

Haven't got access to SQL of the database so have to use php. how can i do this?

i just want to copy one field accross;
INSERT INTO new_table; VALUES ('', '', '', 'this_field', '', '','');

others remain empty.

and if the first field on the new table is id, can i leave this empty and it will fill itself out?

quadmyre

You don't specify which database you're using or whether the tables are in the same DB but assuming they are you can probably use a single INSERT ... SELECT statement to do exactly what you want.
See http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html for full syntax details (from MySQL manual - other DBs may vary).
You can issue the query from within a PHP script just as simply as from the MySQL (etc) client - use the appropriate functions for your DB.
HTH

v3nt

cheers. i actually got this working. i didn't think of this as im too used to SQL!

$connection_l = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");

$query_PD = "SELECT * FROM property WHERE pavailable ='1'";
$result_PD = mysql_query($query_PD) or die ("Error in query: $query. " . mysql_error());

while($myrow_PD = mysql_fetch_array($result_PD)){
$pcode = $myrow_PD["pcode"];

$query = "INSERT INTO map_hg (id, px, py, pcode, pavailable, pstatus, poption_a, poption_b) VALUES ('', '0','0', '$pcode','','','','')";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

}

$query_b = "SELECT * FROM map_hg";
$result_b = mysql_query($query_b) or die ("Error in query: $query. " . mysql_error());
while($myrow_b = mysql_fetch_array($result_b)){
$pcodeb = $myrow_PD["pcode"];
$ass .="$pcodeb<BR>";
$i++;
}
print "$ass<BR> $i"