Basicly what I am trying to do here is tranfer infromation from one Mysql database 2 another via a PHP script. The only thing about it is, that both Mysql database are on different servers, Here is the script I have got so far, but atm the secound connection isnt kicking in and its pulling info from the frist connect, I have tryed mysql_close() but still nothing. All the database selections and pass word and user name are correct also.Any idea?
| Code: |
|
<?php // Make a MySQL Connection $con = mysql_connect("localhost", "user", "pass") or die(mysql_error()); $con = mysql_select_db("database") or die(mysql_error()); $result = mysql_query("SELECT * FROM oakstown WHERE emailed = 'no'") or die(mysql_error()); $total_to_be_emailed = mysql_num_rows($result); While($row = mysql_fetch_array( $result )) { array ($doc[] = "$row[id]"); array ($date2[] = "$row[date]"); array ($invoice_name2[] = "$row[invoice_name]" ); array ($invoice_address2[] = "$row[invoice_address]" ); array ($telephone12[] = "$row[telephone1]" ); array ($telephone22[] = "$row[telephone2]" ); array ($fax2[] = "$row[fax]" ); array ($delivery_name2[] = "$row[delivery_name]" ); array ($delivery_address2[] = "$row[delivery_address]" ); array ($telephone32[] = "$row[telephone3]" ); array ($digger_driver2[] = "$row[digger_drivers]" ); array ($price2[] = "$row[price]" ); array ($payment2[] = "$row[payment]" ); array ($system2[] = "$row[system]" ); array ($distribution_box22[] = "$row[distibution_box]" ); array ($cable2[] = "$row[cable]" ); array ($commission2[] = "$row[comission]" ); array ($size2[] = "$row[size]" ); array ($type_of_lids2[] = "$row[type_of_lid]" ); array ($wall_size2[] = "$row[wall_sizes]" ); array ($wall_quantity2[] = "$row[wall_quantity]" ); array ($facility_to_off_load2[] = "$row[facility_to_off_load]" ); array ($facility_for_artic2[] = "$row[facility_for_delivery]" ); array ($date_of_delivery2[] = "$row[date_of_delivery]" ); array ($am_or_pm2[] = "$row[am_or_pm]" ); array ($directions2[] = "$row[direction]" ); }; mysql_connect("://www.flatlinesolutions.frih.net/", "user", "pass") or die(mysql_error()); mysql_select_db("database") or die(mysql_error()); echo"seound connection<br>"; $i = "0"; While($i < $total_to_be_emailed) { $i = $i+1; mysql_query("INSERT INTO oakstown ( date, invoice_name, invoice_address, telephone1, telephone2, fax, delivery_name, delivery_address, telephone3, digger_driver, price, payment, system, distribution_box, cable, commission, size, distribution_box2, lid_types, l_wall_size, l_wall_quantity, facility_to_off_load, facility_for_artic, date_of_delivery, time_am_or_pm, directions, emailed, sold ) VALUES ( '$date2[$i]', '$invoice_name2[$i] ', '$invoice_address2[$i] ', '$telephone12[$i]', '$telephone22[$i]', '$fax2[$i]', '$delivery_name2[$i]', '$delivery_address2[$i]', '$telephone32[$i]' , '$digger_driver2[$i]', '$price2[$i]', '$payment2[$i]', '$system2[$i]', '$distribution_box2[$i]', '$cable2[$i]', '$commission2[$i]', '$size2[$i]', '$distribution_box22[$i]', '$type_of_lids2[$i]', '$wall_size2[$i]', '$wall_quantity2[$i]', '$facility_to_off_load2[$i]', '$facility_for_artic2[$i]', '$date_of_delivery2[$i]', '$am_or_pm2[$i]', '$directions2[$i]', '$no[$i]', '$no[$i]')") or die(mysql_error()); }; ?> |
