Question reguarding ID in 3 tables

[m1k3]

Hi,

As some of you know im working on getting my car specs into a mysql database.
I was wondering how i can make it so that i know what car is on what ID from the tables.

If i add 3 different car specs one after another

Ex
Honda - Civic Type R
Mazda - 323F
Renault - Clio Sport

ok as the 3 tables all have ID in them and i added the above one after another they would be

ID1 = Honda - Civic Type R
ID2 = Mazda - 323F
ID3 = Renault - Clio Sport

Is there a way i can have all the Mazda specs together as if i add different car manufactures and specs all after each other there will be no organization in the database and this will be a great problem when i come to fetch the data to a web page.

[thorpe]

When it comes to fetching the data you simply use an ORDER BY clause.

SELECT * FROM cars ORDER BY make;

Databases do not store data in any particular order.

[m1k3]

ahhh now i see

Thank you Thorpe 😉 cheers pal