halohalo

<?php include "dbc.php"; $sel_row = mysql_query("select `id`,`product_id` from shopping_tbl"); while($row = mysql_fetch_object($sel_row)){ $id = $row->id; $pid = $row->product_id; list($product_name,$product_name_en) = mysql_fetch_row(mysql_query("select `product_name`,`product_name_en` from product_tbl where product_id='$pid'")); mysql_query("update shopping_tbl set `product_name`='$product_name', `product_name_en`='$product_name_en' where id='$id'"); //echo $product_name." ".$product_name_en; } ?>