difficult to describe but I'll try my best.
The taxi_services table looks like this.
this is the locations table.
Each taxi service has a locations table.(Shown below) Notice only the values in the Active field have changed. It shows in which locations the taxi service is available.
Think of it like the whole table as another field in the taxi_services table.(I dunno if that makes sense)
Is it possible to connect these 2 tables in that way in MySQL? If not are there any other database management system which can do it?
Or if you can think of a completely different way to go about this, please let me know.
Thank you very much
This post has been edited by nK0de: 11 September 2012 - 01:40 AM