Select a state:
Select distinct stovtry.description as statename, stovtry.stovince as stov
from stovtry, shings
where stovtry.stovince = shings.stovince
and type = '6' and brand > '0'
order by stovtry.description
#statename#
Or pick a city (two-letter state optional)
Ohwy.mobi is expanding north, east and south from the Oregon Coast. We may not have yet reached your city. You'll find it a very useful tool for your cell phone while you travel. Pick a general destination, or start with a specific city. You'll get the weather and a link to a weather forecast. If there's a nearby Web cam, usually for the highway, we'll link you to that. Most often, we can take you to a Google map that you can zoom into or out of.
Find upcoming events, community theater, shopping specials, and much more. If you have a large screen, you can bring up the Web sites of many local businesses and organizations, or you can click on the phone number and dial them up. Ohwy.mobi is designed to maximum information about what's happening right now, with the minimum requirements for bandwidth and screen size.
Select description from stovtry where stovince = '#x#'
Select a travel destination in #statename#:
Select distinct BrandTitle, BrandCode, BrandText from Brands, shings, stovtry
where BrandCode = shings.brand
and type = '6'
and stovtry.stovince = shings.stovince
and stovtry.stovince = '#x#'
order by BrandCode
#BrandTitle# #BrandText#
Or pick a city in #statename#.
Ohwy.mobi is expanding north, east and south from the Oregon Coast. We may not have yet reached your city.
Select BrandTitle, BrandKW from Brands where BrandCode = '#y#'
Select BrandTitle from Brands where BrandCode = '#y#'
Select a city or keywords in #brandname#:
Cities:
Select title, record from shings
where brand = '#y#'
and type = '6'
order by title
#cityURL#
update shings set mobicityURL = '#cityURL#'
where record = '#record#'
#listlen(coupon)# Coupons
Keywords:
SELECT DISTINCT KWDesc, KWID
FROM shings, KWMaster
WHERE TYPE <> '6'
AND brand = '#y#'
AND BrandKW = KWID
ORDER BY KWDesc
#KWDesc#
#listlen(coupon)# Coupons
Select BrandTitle from Brands where BrandCode = '#y#'
#BrandTitle#
Select BrandTitle, KWDesc from Brands, KWMaster
where BrandCode = '#y#' and KWID = '#val(rob)#'
#KWDesc#
Select record, title, mailstreet, mailcity, description, voice, brandcity, offsite_link, geocoded from shings
where brand = '#y#' and brandkw = '#val(rob)#'
order by title
Select title, mobicityURL from shings where record = '#brandcity#'
#mobicityurl#
#title#
#title#
Select * from announcements
where anrecord = '#record#' and anstart < '#thisdate#' and anstop > '#thisdate#'
order by anstop
limit 1
Select * from openclose where
ocshing = '#record#' and ((ocdate = '#shortdate#' and occlose > '#thistime#') or ocdate > '#shortdate#')
order by ocdate
limit 1
#mailstreet#, #mailcity#
Map
#voice# #opcl# #readerboard#
Select * from performances
where pdt > '#lowdt#' and pdt < '#hidt#' and panid = '#testanid#'
#prepos# #timeformat(fullpdt,'short')#
Select record, title, description, stovince, geocoded from shings where record = '#rob#'
#title#.
Select nextmobi from nextcities where nextid = '#rob#'
Nearby towns/cities.
",x,i)>
",x,i)>
#temperature#F #conditions# Click for forecast
Select * from webcams where camcity = '#rob#' limit 1
Web Cam
Select * from announcements
where anrecord = '#rob#' and anstart < '#thisdate#' and anstop > '#thisdate#'
order by anstop
limit 1
#readerboard#
Select * from performances
where pdt > '#lowdt#' and pdt < '#hidt#' and panid = '#testanid#'
#prepos# #timeformat(fullpdt,'short')#
Select record, title, mailstreet, mailcity, description, voice, brandKW, offsite_link, brandcity, KWDesc, geocoded
from shings, KWMaster
where brandcity = '#rob#' and brandKW = KWID
order by KWDesc, title
#KWDesc#
#title#
#title#
Select * from announcements
where anrecord = '#record#' and anstart < '#thisdate#' and anstop > '#thisdate#'
order by anstop
limit 1
Select * from openclose where
ocshing = '#record#' and ((ocdate = '#shortdate#' and occlose > '#thistime#') or ocdate > '#shortdate#')
order by ocdate
limit 1
#mailstreet#, #mailcity#
#voice# #opcl# #readerboard#
Select * from performances
where pdt > '#lowdt#' and pdt < '#hidt#' and panid = '#testanid#'
#prepos# #timeformat(fullpdt,'short')#
