|
|
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. |
|
SEARCH BOX: |
|
|
Select your bar search criteria for #url.county# County, #url.state#. |
|
|
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 your bar search criteria for #form.county# County, #form.state#. |
|
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# |
|
Website and Contents © 2003 Barspecial.com
|
|