GoFuckYourself.com - Adult Webmaster Forum - View Single Post

eMonk · 12-12-2011, 01:19 PM

That worked thanks nation-x.

The table model_in_city is picking up multiple results for model.id in British Columbia because they can be shown in multiple cities but only want to display them once in British Columbia.

For example:

Code:

Table: model_in_city
column: model_id = 1
column: city_id = 33
column: city_display = 1

column: model_id = 1
column: city_id = 34
column: city_display = 2

Now let's say city_id 33 and 34 are both in British Columbia... how can I just display them just once in British Columbia instead of 2?

12-12-2011, 01:19 PM
eMonk Confirmed User Industry Role: Join Date: Aug 2003 Location: Canada Posts: 2,310	That worked thanks nation-x. The table model_in_city is picking up multiple results for model.id in British Columbia because they can be shown in multiple cities but only want to display them once in British Columbia. For example: Code: Table: model_in_city column: model_id = 1 column: city_id = 33 column: city_display = 1 column: model_id = 1 column: city_id = 34 column: city_display = 2 Now let's say city_id 33 and 34 are both in British Columbia... how can I just display them just once in British Columbia instead of 2?