Need Help

:confused; I need help. Ideally what I want is a locator. So if someone wants
to locate a marketer in their city all they have to due is select a city from
the pull down menu and the results will show on the results page. My problem
is that I can only get the marketer to show up in one city. How do I get them
to show up in multiple cities. I have a database with columns as follows c1,
c2 for the additional cities they are in. I looked at the Wildlife Project and
it just shows a company in just one state, but I how do I get it to show a
marketer in different cities like I want.

WHERE 'c1' LIKE 'name' OR 'c2' LIKE 'name'

Craig


"aelawson" <webforumsuser (AT) macromedia (DOT) com> wrote

:confused; I need help. Ideally what I want is a locator. So if someone
wants
to locate a marketer in their city all they have to due is select a city
from
the pull down menu and the results will show on the results page. My
problem
is that I can only get the marketer to show up in one city. How do I get
them
to show up in multiple cities. I have a database with columns as follows
c1,
c2 for the additional cities they are in. I looked at the Wildlife
Project and
it just shows a company in just one state, but I how do I get it to show a
marketer in different cities like I want.