Hi Forum,
I have 2 tables as follows:
Table: vehicle
Field: vehicle - varchar(100)
Table: suppliers
Fields: vehicle_name - varchar(100) & vehicle_image - varchar(100)
Via Visual Editor 'suppliers table', add page, vehicle_name field, i have set up a lookup table to table vehicle, field vehicle
I have populated the vehicle table with 3 static entries: bike, car & van
From suppliers_add.php i can select from the drop down field either bike, car or Van .... this bit work fine!!!
Here's where i need some help
When the user goes to the suppliers_add.php page and selects "car", i need a way to display a preset image car.gif in the vehicle_image field. Likewise if the user selects "bike" then the image motorbike.gif will be displayed.
Your help and support would be much appreciated.
Lisa