SELECT * FROM paintings WHERE active = 1 ORDER BY name SELECT * FROM paintings WHERE active = 0 ORDER BY name Admin: List All Paintings
paintings galleries giclees nancy
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#"
checked="checked" />
checked="checked" />
#existing.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 = #existing.galleryID# #galleries.gName# $#inactive.price# #inactive.dimensions_x#" x #inactive.dimensions_y#"
checked="checked" />
checked="checked" />
#inactive.rank#