ho inserito il ciclo, ma non funziona, puoi correggermelo?
Codice PHP:
if ((isset($_GET['id'])) && ($_GET['id'] != "")) {
$deleteSQL2 = "DELETE FROM photos WHERE ptid=".$_REQUEST['id'];
//echo $deleteSQL;
//die();
mysql_select_db($database_myconn, $myconn);
$Result2 = mysql_query($deleteSQL2, $myconn) or die(mysql_error());
$deleteGoTo2 = "a_index.php?id=".$_REQUEST['id'];
header(sprintf("Location: %s", $deleteGoTo2));
}
function delete($id) {
$query = "SELECT * FROM photos WHERE ptid=".$_REQUEST['id'];
$esegui = mysql_query($query);
while ($result = mysql_fetch_array($esegui)) {
//delete photos from file
unlink('admin/photos/uploads/'.$result);
unlink('admin/photos/uploads/thumbs/tn_'.$result);
unlink('admin/photos/uploads/small_thumbs/tn_'.$result);
}
if ((isset($_GET['id'])) && ($_GET['id'] != "")) {
$deleteSQL = sprintf("DELETE FROM items WHERE id=%s",
GetSQLValueString($_GET['id'], "int")) . " and mid = " . $_SESSION['memberID'];
//echo $deleteSQL;
$Result1 = mysql_query($deleteSQL, $myconn) or die(mysql_error());
$deleteGoTo = "a_index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
}
grazie