Copiar archivos segun consulta

[s00rk]

Código PHP:

$r = mysql_fetch_row(mysql_query("SELECT product_id FROM product WHERE product_id = (SELECT MIN(product_id) FROM product"));
$id_minimo = $r['product_id'];
 
$r = mysql_fetch_row(mysql_query("SELECT product_id FROM product WHERE product_id = (SELECT MAX(product_id) FROM product"));
$id_maximo = $r['product_id'];
 

Código PHP:

for ($i=$id_minimo; $i<=$id_maximo; $i++)
{
    $img = mysql_fetch_row(mysql_query("SELECT image FROM product WHERE product_id = '".$i."'"));
    $origen = $img; //SELECT image FROM product WHERE product_id = $i
    copy($origen, $destino);
    echo "se ha copiado la imagen:" . $origen . "<br />";
  }