echo "<td>{$filename}</td>"; $image_name_array = explode('.', $file); $image_name = ""; for ($i = 0; $i < sizeof($image_name_array) - 1; $i++) { $image_name .= $image_name_array[$i]; } $extension = "." . $image_name_array[sizeof($image_name_array) - 1]; $query = "select * from {$table} where {$dbcolumn}='{$image_name}'"; $result = mysql_query($query) or die(mysql_error()); $num_rows = mysql_num_rows($result); if ($num_rows == 1) { $product_data = mysql_fetch_assoc($result); $prodct_id = $product_data[$table . '_id']; $product_name = trim($product_data[$segment . '_name']); $new_name = ""; $new_name = $obj->ImageNamingFormat($product_name); $setimage = $new_name . $extension; $update_query = "update {$table} set image = '{$setimage}' where {$dbcolumn}='{$image_name}'"; $update = mysql_query($update_query); if (!copy($filename, "temp/" . $setimage)) { echo "<td style='color:red'><b>{$file}</b> failed to copy as <b>{$setimage}</b></td>"; } else { if (is_dir("upload/{$segment}")) { $imagesizes_array = explode(',', $imagesizes); if (sizeof($imagesizes_array) >= 1) { for ($i = 0; $i < sizeof($imagesizes_array); $i++) { $xy = array(); if ($imagesizes_array[$i] != '') { $xy = explode('x', $imagesizes_array[$i]); $x = (int) trim($xy[0]); $y = (int) trim($xy[1]);