SELECT * from tblChambers WHERE ChamberID=#mychamber# #MySQL# SELECT tblBiz.*, tblBiz.URL AS YesURL, tblCities.CityURL FROM tblCities RIGHT JOIN tblBiz ON tblCities.City = tblBiz.City WHERE tblBiz.BizID > 0 AND (tblBiz.BizName LIKE '%#string#%' OR tblBiz.category1 LIKE '%#string#%' OR tblBiz.category2 LIKE '%#string#%' OR tblBiz.category3 LIKE '%#string#%' OR tblBiz.category4 LIKE '%#string#%' OR tblBiz.category5 LIKE '%#string#%' OR tblBiz.keywords LIKE '%#string#%') AND (#ChamberSearch# = 1) AND (tblBiz.category1 LIKE '%#mytype#%' OR tblBiz.category2 LIKE '%#mytype#%' OR tblBiz.category3 LIKE '%#mytype#%' OR tblBiz.category4 LIKE '%#mytype#%' OR tblBiz.category5 LIKE '%#mytype#%') AND (tblBiz.city LIKE '%#mycityin#%') order by priority desc, BizName

Found #GetBizList.RecordCount# entries.
Ozark Digital Data's Official Lake of the Ozarks Website Business Database Search
Datasource: #GetChamberInfo.ChamberName# Members Category: #type#All Categories Location: #mycityin#All Categories
#BizName# #BizName# #Phone1#  #Phone2#(Fax: #FaxPhone#) #Category1#   #Category2#   #Category3#   #Category4#   #Category5#	#City##City#
TRY ANOTHER SEARCH
Provided as a service to the Lake of the Ozarks and surrounding communities by Ozark Digital Data and Advertisnet Internet Services. If you would like to search our entire database, click here. © #DateFormat("#Now()#","yyyy")# Ozark Digital Data, LLC. All rights reserved.