If I remove the following sql statement
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
"this outputs the Vehicle manufacturer Name instead of the id"
The page loads without any errors on my live server.
I have two sql statements utilising this sql statement
The one above and this one
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
WHERE vehicle.VehicleCotw = 1
ORDER BY vehicle.VehicletUpdateDate ASC LIMIT 1
Any help would be appreciated.
I have added both files in a zip along with a sql dump of my live server.
Jonathon