This topic is locked

Get list of cities with businesses

3/5/2008 6:19:43 PM
PHPRunner General questions
B
bullet author

I am getting a little better. Thanks for all the help. I need more.

I am making a table with cities and I would like to get a list of cities that have a business in my business name column. If the city doesn't have a business in it, it will not show. I know I need a where clause, but I don't know how to say it.

Select * from cities where = business name column.

I need help. I hope you can understand.

Thanks