SQL Update Query

require('includes/application_top.php');



 $products_des_query = tep_db_query("select * from products_description");



 while ($products_des_values = tep_db_fetch_array($products_des_query))

{

 

$original_products_id = $products_des_values['products_id']; // Original



$products_related_id1 = $products_des_values['products_related_id1'];

$products_related_id2 = $products_des_values['products_related_id2'];

$products_related_id3 = $products_des_values['products_related_id3'];



//echo $products_related_id1.' Related';

//$sql = "update products set products_id = '" .$products_model ."' where products_model = '" . $products_model . "'";



//////////////////////////////////////

$products_query1 = tep_db_query("select products_id from products where products_model = $products_related_id1");



 while ($products_values1 = tep_db_fetch_array($products_query1))

{

$products_model = $products_values1['products_model'];

$products_id1 = $products_values1['products_id'];



//echo $original_products_id.' ORI ID';

//echo $products_id1.' DUP ID';



}

$sql1 = "insert into products_xsell (products_id, xsell_id) values ( '$original_products_id' , '$products_id1')";

$update_query1 = tep_db_query($sql1);

//////////////////////////////////////



//////////////////////////////////////

$products_query2 = tep_db_query("select products_id from products where products_model = $products_related_id2");



 while ($products_values2 = tep_db_fetch_array($products_query2))

{

$products_model = $products_values2['products_model'];

$products_id2 = $products_values2['products_id'];



//echo $products_model.' Model';



}

//////////////////////////////////////

$sql2 = "insert into products_xsell (products_id, xsell_id) values ( '$original_products_id' , '$products_id2')";

$update_query2 = tep_db_query($sql2);

//////////////////////////////////////

$products_query3 = tep_db_query("select products_id from products where products_model = $products_related_id3");



 while ($products_values3 = tep_db_fetch_array($products_query3))

{

$products_model = $products_values3['products_model'];

$products_id3 = $products_values3['products_id'];



//echo $products_model.' Model';



}

//////////////////////////////////////



$sql3 = "insert into products_xsell (products_id, xsell_id) values ( '$original_products_id' , '$products_id3')";

$update_query3 = tep_db_query($sql3);

}

Genrerating Link.... 15 seconds.

Your Link is Ready.

Share this post