Tag Archives: Rename Product Image

Rename Product Image in SQL Query Oscommerce

oscommerce




How to Rename Product Image in SQL Query in osCommerce. In Oscommerce it is simple to rename the product image in sql query. IN the below is the simple script to sove this 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 […]