show delete if not in both tables
i have two joined tables gallery and gallery history i was able to show inserted and updated now if i delete from gallery and not history i want to show deleted
<?php
if ("".$row_gallery['created'] ."" == "".$row_gallery['historycreated'] ."") { // WebAssist Show If
?>
Inserted
<?php
} // ("".$row_gallery['created'] ."" > "".$row_gallery['updated'] ."")
?>
<?php
if ("".$row_gallery['created'] ."" > "".$row_gallery['historycreated'] ."") { // WebAssist Show If
?>
Updated
<?php
} // ("".$row_gallery['created'] ."" > "".$row_gallery['created'] ."")
?>
<?php
if ("".$row_gallery['pg1_gallery.id'] ."" != "".$row_gallery['pg1_galleryhistory.id'] ."") { // WebAssist Show If
?>
Deleted
<?php
} // ("".$row_gallery['id'] ."" != "".$row_gallery['id'] ."")
?>
------------------------------------
and the record set
SELECT count(pg1_gallery_images.imgsrc) AS `number of images`
, pg1_gallery_images.*
, pg1_gallery_images.photoComment
, pg1_gallery.id
, pg1_gallery.created
, pg1_gallery.GalleryName
, pg1_gallery_images.gallery_id
, pg1_galleryhistory.*
, pg1_galleryhistory.id
, pg1_galleryhistory.historycreated
, pg1_galleryhistory.historyGalleryName
, pg1_gallery_images.watermark_text
FROM
pg1_gallery
LEFT OUTER JOIN pg1_gallery_images
ON pg1_gallery.id = pg1_gallery_images.gallery_id
RIGHT OUTER JOIN pg1_galleryhistory
ON pg1_gallery.id = pg1_galleryhistory.id
GROUP BY
pg1_gallery_images.gallery_id
, pg1_gallery.id
, pg1_gallery.id
, pg1_galleryhistory.historycreated
, pg1_galleryhistory.historyGalleryName
, pg1_gallery_images.watermark_text
ORDER BY
pg1_gallery.id DESC