Need to display data from a mysql database

[af1]

Hi i am currently designing my website, Currently i have a Vehicle application list that was coded using tables and inputting the data manually, this took ages! also if a new product becomes available it needs to be entered manually.

 

 

So i set about designing a mysql database to include all this data, and allow me to update this information easier.

I seem to have created the database fine with all the correct fields etc, also i have created seperate tables for each manufacturer.

 

 

here is an example of my HTML page and table http://tunethat.com/alfa.html

now i have input all that data into mysql database using phpmyadmin, but now do i display it neatly on a webpage?

 

i have been experimenting with code (im new to this) on this page http://tunethat.com/a.php

 

which is brill, i mean yeah... its displayed however it isnt in the format i require

Obviously i want all the alfa stuff together but then i want it seperate for each model (am i going to have to have a seperate table for each model) and also if you look on the audi table i want to have Diesel, Petrol etc. seperated also! you can see this on http://tunethat.com/audi.html

 

can someone offer some friendly advice on this to a total php nuubbe (infact a total web design nuube)

 

cheers

Alan