Hi Balazs,
The situation: I have 2 tables in an adverising site. In one table, i have
the cities used by advertisers, and in the other there are the ads.This ad
table has a field which refers to the id of the city in that table.
The problem: what mysql method should i use if i want to
Since you gave no real details of your table structure, I'll conjecture.
Assume city table and advert table is defined as:
CREATE TABLE city (
city_id int not null, auto_increment,
city_name varchar(50) default
)
CREATE TABLE adverts (
ad_id int not null auto_increment,
ad_text varchar(200)