SELECT * FROM pierre_paintings WHERE active = 1 and archive <> 1 ORDER BY name SELECT * FROM pierre_paintings WHERE active = 0 ORDER BY name SELECT * FROM pierre_paintings WHERE active = 1 and archive = 1 ORDER BY name Admin: List All Paintings
Active Paintings
Thumbnail Name Gallery Price
Size
Active
Sold
Rank
 
#existing.name# SELECT gallery.ID as gID, gallery.name as gName, paintings.galleryID as pgID, paintings.ID as pID FROM gallery, paintings WHERE gallery.ID = #existing.galleryID# #galleries.gName# $#existing.price# #existing.dimensions_x#" x #existing.dimensions_y#"
yes
yes
#existing.rank#


Archived Paintings
Thumbnail Name Gallery Price
Size
Active
Sold
Rank
 
#archived.name# Ortenstone Delattre Fine Art $#archived.price# #archived.dimensions_x#" x #archived.dimensions_y#"
yes
yes
#archived.rank#


Inactive Paintings
Thumbnail Name Gallery Price
Size
Active
Sold
Rank
 
#inactive.name# SELECT gallery.ID as gID, gallery.name as gName, paintings.galleryID as pgID, paintings.ID as pID FROM gallery, paintings WHERE gallery.ID = #inactive.galleryID# #galleries.gName# $#inactive.price# #inactive.dimensions_x#" x #inactive.dimensions_y#"
yes
yes
#inactive.rank#