View Single Post
Old 03-12-2011, 07:37 AM  
eMonk
Confirmed User
 
Industry Role:
Join Date: Aug 2003
Location: Canada
Posts: 2,310
MYSQL: Multiple values in column

My database and columns:

province (province_id, ..)
city (city_id, province_id, ..)
model (model_id, age, height_in_cm, hair_color, measurements, eye_color, description, ..)
model_in_city (model_id, city_id)

Now I want to display all models in the chosen city by the user but each model can chose up to 4 city placements. How can this be done?
eMonk is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote