File: /home/awaldron/www/archive/ras/admin/gallery/gallery_delete.php
<?php
include "../../f_db.php";
dbconnect();
$gal = substr($_REQUEST['gal'],4);
$photos = rset("SELECT * FROM ras_gallery_phogal as A, ras_gallery_photo as B WHERE A.gal_id=".$gal." AND A.photo_id=B.photo_id");
// DELETE PHOTOS
foreach ($photos as $p) {
$upd = qupdate("DELETE FROM ras_gallery_phogal WHERE photo_id=".$p['photo_id']." AND gal_id=".$gal);
//$upd = qupdate("DELETE FROM ras_gallery_photo WHERE photo_id=".$p['photo_id']);
//unlink('/home/awaldron/public_html/ras/gallery/lg_'.$p['photo_file']);
//unlink('/home/awaldron/public_html/ras/gallery/tn_'.$p['photo_file']);
}
// DELETE GALLERY
$upd = qupdate("DELETE FROM ras_gallery WHERE gal_id=".$gal);
?>