BarSpecial.com - Your Personal Guide to Cheap Food and Drink Specials

SELECT "State" FROM States ORDER BY "State_ID" ASC

SEARCH BOX:

Select your state from the list below:

SEARCH BOX:
Select your county/area in #url.state# from the list below.
select County from Area where State = '#url.state#'

SEARCH BOX:
select County from Area where State = '#url.state#'
Select your bar search criteria for #url.county# County, #url.state#.

Special Type: Day:

SELECT * FROM "bar_info" WHERE State = '#URL.State#' AND County = '#URL.County#' order by bar_info.barname asc

#recordset3.recordcount# bars currently match your search criteria.
#Recordset3.BarName#
#Recordset3.Address#
#Recordset3.City#, #Recordset3.State# #Recordset3.postalcode#
#Recordset3.BarPhone#
#Recordset3.BarName#
#Recordset3.Address#
#Recordset3.City#, #Recordset3.State# #Recordset3.postalcode#
#Recordset3.BarPhone#

SEARCH BOX:
select County from Area where State = '#form.state#'
Select your bar search criteria for #form.county# County, #form.state#.
Special Type: SELECT SpecialType FROM "Special_Types" ORDER BY SpecialID ASC Day:

SELECT distinct bar_info.barid, bar_info.state, bar_info.packagetype, bar_info.barname, bar_info.logourl,bar_info.address,bar_info.city,bar_info.state,bar_info.postalcode,bar_info.barphone , specials.specialtype,specials.barid,specials.day FROM specials, bar_info WHERE specials.specialtype='#form.special#' and specials.barid = bar_info.barid and bar_info.state ='#form.state#' and bar_info.county='#form.county#' and specials.day='#form.days#' and bar_info.packagetype > 0 order by bar_info.barname asc

#recordset4.recordcount# bars currently match your search criteria.
#Recordset4.BarName#

#Recordset4.Address#

#Recordset4.City#, #Recordset4.State# #Recordset4.postalcode#
#Recordset4.BarPhone#
#Recordset4.BarName#

#Recordset4.Address#

#Recordset4.City#, #Recordset4.State# #Recordset4.postalcode#
#Recordset4.BarPhone#