Sure no problem.
I have created two record sets using the following SQl statements on two different pages respectfully.
rsCaroftheweek
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
and WADAvehicle
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
I have no issues with the above sql statements on either pages when running on xampp.
However, when these pages are uploaded to my live server and view my pages i get the following error and the page does not load.
Table 'web81-ahc200db.settings' doesn't exist.
By removing the following sql statement code from both record sets the pages load.
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
I am at a loss why on my testing server xammp it work fine but not on my live server. hmm
Kind regards
Jonaathon
