select distinct ID, Name, DisplayFlag, PageID, WebsiteID, BusinessName, Email, Website, Phone, Fax, Address1, Address2, Title, Blurb, Seq from `col_providers` inner join col_providercategorylink on id = providerid where websiteid = and displayflag = 'Y' and pageid = 1 and categoryid = order by seq, name select * from `col_categories` where websiteid = and displayflag = 'Y' and pageid = 1 and id =

Back

#qGetCategoryName.category_name#

All Categories
#qGetProvidersByCat.name#
#qGetProvidersByCat.businessname#
#qGetProvidersByCat.title#

#qGetProvidersByCat.blurb#

Phone: #qGetProvidersByCat.phone#

Fax: #qGetProvidersByCat.fax#

Email: #replace(qGetProvidersByCat.email,"@"," [-AT-] ")#

Website: #qGetProvidersByCat.website#

Address: #qGetProvidersByCat.address1# #qGetProvidersByCat.address2#

See All Professionals