Product Image Rename SQL Query

Written By Apo January 24, 2012 Add Comment

How to change products image name in osCommerce.

require('includes/application_top.php');

 $products_query = tep_db_query("select * from products");



 while ($products_values = tep_db_fetch_array($products_query)) 

{

  

$products_id = $products_values['products_id'];

$products_image = $products_values['products_image'];

$image = $products_image.'.jpg';



//echo $image;



//echo $products_id;



//echo $products_image;



$sql = "update products set products_image = '" .$image ."' where products_id = '" . (int)$products_id . "'";



$update_query = tep_db_query($sql); 

}