i have an array (Car, SUV, Truck, Bike) that's used in a form. when the option is selected the value is saved to the customers account in database. Value is the array position (eg: 0, 1, 2, 3).
I want this info to be displayed on another page in a table using php as i'm using magento. Currently it only displays the database saved value (0,1,2,3), but i want it to show as ((Car, SUV, Truck, Bike). How do i do this?
i need a way to make it know that 0=Car, 1=SUV, 2=Truck, 3=Bike)
heres what the table looks like now:
The make column represents the vehicle manufacturer (toyota, honda, etc)and type represents (car, bike, suv)
Please help!
Make the table field type
an enum that matches the array you specified.
More Details
An ENUM data type is an array that maps a key to a value. If you change the column type
to an enumeration, then your Database will display an human readable value instead of a number (e.g., Car, SUV, Truck, Bike).
Also, you can interact with the enum using the Key or the Value so you shouldn't have to change your current implementation.