$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
$ok = @mysql_query("UPDATE productinfo SET category ='$category',link='$link',plink='$plink',image='$image',keywords='$keywords' WHERE partname='$productname'");
if ($ok) {echo("
Successful Product Info Update
");
}else{die ("
Error Editing Product Info in Data Base!
".
'Error:' . mysql_error() . '
');
}
$ok2 = @mysql_query("UPDATE prices SET description='$description',list ='$list',retail='$retail',wholesale='$wholesale',dealer='$dealer',distributor='$distributor',cost='$cost',date='$new_date' WHERE productname='$productname'");
if ($ok2) {echo("
Successful Product Price Update
");
}else{die ("
Error Editing Product Prices in Data Base!
".
'Error:' . mysql_error() . '
');
}
$ok3 = @mysql_query("UPDATE shipping SET type='$type',o_country='$o_country',o_city='$o_city',o_code='$o_code',custom_value='$custom_value',currency='$currency',weight_lb='$weight_lb',length_in='$length_in',width_in='$width_in',height_in='$height_in',fixed_price='$fixed_price',percent_of_sale='$percent_of_sale' WHERE productname='$productname'");
if ($ok3) {echo("
Successful Product Shipping Update
");
}else{die ("
Error Editing Product Shipping in Data Base!
".
'Error:' . mysql_error() . '
');
}
?>