SELECT * FROM subcat s INNER JOIN category c ON s.catid=c.catid WHERE s.subcatid = #subcat# SELECT * FROM subcat sc INNER JOIN category c ON sc.catid=c.catid WHERE c.catid = #getthissubcat.catID# ORDER BY sc.ordervalue, subcat SELECT * FROM photos WHERE subcatid = #url.subcat# AND thumb <> 'spacer.gif' ORDER BY photokey
Home » #getthissubcat.category# » #getthissubcat.subcat#

#category#
  &##8250; #subcat#

 

#heading#
#getphotos.caption#
#getphotos.caption#width="68" height="54" border="0" align="center">
#getthissubcat.description1#