SELECT * FROM Industry WHERE ID = #URL.ID# SELECT * FROM Category WHERE Industry = #URL.ID# SELECT * FROM Business WHERE Industry = #URL.ID# AND Category = #URL.category# AND showListing = 'Y' ORDER BY name SELECT * FROM Business WHERE Industry = #URL.ID# AND name LIKE '#letter#%' AND showListing = 'Y' ORDER BY name

Results #URL.startrow#-#endrow# of #businesses.recordCount# No Results Found. previous previous        next next

UPDATE Business SET accountStatus = "D", showListing = "N" WHERE ID = #businesses.ID# #businesses.currentRow#. #name# #name# - Shop Online #street# #city#, #State# #zip# #country# Phone: #phone# Fax: #fax# http://#url# previous previous        next next

Browse Businesses by Category: #categories.name#

Browse Businesses Alphabetically: #chr(letter)# |