[loki421]

Yeah that second query would work, but it would return all the multiple models, so when i loop over the list it would repeat models, ie:

3-Series
3-Series
3-Series
5-Series
5-Series
6-Series
6-Series
6-Series
6-Series
etc

because all the models are seperate rows in the database, and each model might have two or three variants, but they all have the same make (BMW). If you want to PM me i'll send you a backup of the db so you can see what's in there?

For example,

select model from products where model = 3-Series

would return:

3-Series
3-Series
3-Series

if i had 3 varinats under that model.

Does that make sense?

I only have ID, make, model and image in the 'models' table, the rest of the data is in the 'products' table,

I have heard of 'inner join' but never used it, wouldn't know how to lol

Send me your email and i'll send you the db if you like?

(Oh, and it's mySQL v5)