Code: Select all
<?php
mysql_connect("localhost","web11_u3","password");
@mysql_select_db("web11_db3") or die( "Unable to select database 1");
$query="SELECT * FROM xcart_products";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num==0)
{
$data .= "Something screwed up!";
}
else
{
$count=0;
while ($count < $num)
{
$productid = mysql_result($result,$count,"productid");
$productcode = mysql_result($result,$count,"productcode");
$product = mysql_result($result,$count,"product");
$provider = mysql_result($result,$count,"provider");
$distribution = mysql_result($result,$count,"distribution");
$weight = mysql_result($result,$count,"weight");
$list_price = mysql_result($result,$count,"list_price");
$descr = mysql_result($result,$count,"descr");
$fulldescr = mysql_result($result,$count,"fulldescr");
$avail = mysql_result($result,$count,"avail");
$rating = mysql_result($result,$count,"rating");
$forsale = mysql_result($result,$count,"forsale");
$add_date = mysql_result($result,$count,"add_date");
$views_stats = mysql_result($result,$count,"views_stats");
$sales_stats = mysql_result($result,$count,"sales_stats");
$del_stats = mysql_result($result,$count,"del_stats");
$shipping_freight = mysql_result($result,$count,"shipping_freight");
$free_shipping = mysql_result($result,$count,"free_shipping");
$discount_avail = mysql_result($result,$count,"discount_avail");
$min_amount = mysql_result($result,$count,"min_amount");
$dim_x = mysql_result($result,$count,"dim_x");
$dim_y = mysql_result($result,$count,"dim_y");
$dim_z = mysql_result($result,$count,"dim_z");
$low_avail_limit = mysql_result($result,$count,"low_avail_limit");
$free_tax = mysql_result($result,$count,"free_tax");
$product_type = mysql_result($result,$count,"product_type");
$manufacturerid = mysql_result($result,$count,"manufacturerid");
$return_time = mysql_result($result,$count,"return_time");
$link = mysql_connect("localhost","web11_u4","password");
@mysql_select_db("web11_db4") or die( "Unable to select database 2");
$sql = "INSERT INTO xcart_products (productid, productcode, product, provider, distribution, weight, list_price, descr, fulldescr, avail, rating, forsale, add_date, views_stats, sales_stats, del_stats, shipping_freight, free_shipping, discount_avail, min_amount, dim_x, dim_y, dim_z, low_avail_limit, free_tax, product_type, manufacturerid, return_time) VALUES ('$productid', '$productcode', '$product', '$provider', '$distribution', '$weight', '$list_price', '$descr', '$fulldescr', '$avail', '$rating', '$forsale', '$add_date', '$views_stats', '$sales_stats', '$del_stats', '$shipping_freight', '$free_shipping', '$discount_avail', '$min_amount', '$dim_x', '$dim_y', '$dim_z', '$low_avail_limit', '$free_tax', '$product_type', '$manufacturerid', '$return_time')";
mysql_query($sql);
mysql_close($link);
mysql_connect("localhost","web11_u3","password");
@mysql_select_db("web11_db3") or die( "Unable to select database 3");
$count++;
}
}
echo "Done!";I wasn't sure if this was necessasrily PHP or database related, so move where needed.