Andrew wrote:
ok this is making sense and I should have thought about this before* I created
my city table as now I have a city table that in effect is useless and
comlicated the existing queries :(
Well, your city table probably isn't useless... it can be used to
translate city IDs into city na
>Sent: 19 March 2003 17:59
>Cc: MySQL-Lista
>Subject: Re: another table to query!
>
>
>Andrew wrote:
>
>>I have done this and have now started to populate the items_city
>table with the
>>appropriate records what I now need to do is show the records using the city
Andrew wrote:
I have done this and have now started to populate the items_city table with the
appropriate records what I now need to do is show the records using the city
items_table. At the moment the records are displayed when a city is selected bu
the cityID is from the items table. Like this:
Andrew wrote:
I have just discovered through luck that I need to have the same record in
(table items) accessable if it is listed as being in more than one city (table
city). Obviously I don't want to create new records for the same item so it can
be displayed if it's in different cities. Is the
yID' ORDER BY CityID");
Presumably I need to do a JOIN ?
Andrew
>-Original Message-
>From: Bruce Feist [mailto:[EMAIL PROTECTED]
>Sent: 19 March 2003 16:53
>To: [EMAIL PROTECTED]
>Subject: Re: another table to query!
>
>
>Andrew wrote:
>
>>I have just discover
