<? 
session_start();
if ($_SESSION['login'] != 1) {
header("location:index.php?error=2");
}


include "modulos/conexion.php";
$id_prod=$_GET['id_prod'];

$sql = "SELECT * FROM fotos WHERE id_prod=$id_prod" ;
$rs_clean = mysql_query($sql);

while($fila_clean=mysql_fetch_array($rs_clean)){
	$foto_clean=$fila_clean['foto'];
	
	if(strlen($foto_clean)>0){
		unlink("archivos/".$foto_clean);
	}
}

$sql_del = "DELETE FROM fotos WHERE id_prod=$id_prod";
mysql_query($sql_del);
$sql_op = "OPTIMIZE TABLE fotos";
mysql_query($sql_op);

$sql_del_col = "DELETE FROM color WHERE id_prod=$id_prod";
mysql_query($sql_del_col);
$sql_op_col = "OPTIMIZE TABLE color";
mysql_query($sql_op_col);

$sql_del_siz = "DELETE FROM size WHERE id_prod=$id_prod";
mysql_query($sql_del_siz);
$sql_op_siz = "OPTIMIZE TABLE size";
mysql_query($sql_op_siz);

$sql2 = "DELETE FROM productos WHERE id_prod=$id_prod";
mysql_query($sql2);
$sql3 = "OPTIMIZE TABLE productos";
mysql_query($sql3);
header("location:prod.php");
?>