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

you may have to change the join types being used in order to accomplish this.

when the gallery is deleted the $row_gallery['pg1_gallery.id'] will return NULL

so use:
if($row_gallery['pg1_gallery.id'] == NULL) {

ok i did this
<?php
if ("".$row_gallery['GalleryName'] ."" == "") { // WebAssist Show If
?>
Deleted
<?php
} // ("".$row_gallery['GalleryName'] ."" == "")
?>
deleted shows up but inserted is still there

i think i got it to work

how do you show only if two rows are equal

if ("".$row_gallery['created'] ."" == "".$row_gallery['historycreated'] ."") {


should already do that

yes i thinks its good have to make sure all criteria is the same or different i was close just needed the push thanks

you would need another condition around the inserted if statement:
<?php
if ("".$row_gallery['GalleryName'] ."" != "") { // WebAssist Show If
?>
<?php
if ("".$row_gallery['created'] ."" == "".$row_gallery['historycreated'] ."") { // WebAssist Show If
?>
Inserted
<?php
} // ("".$row_gallery['created'] ."" > "".$row_gallery['updated'] ."")
?>
<?php
} // ("".$row_gallery['GalleryName'] ."" != "")
?>