Tweet
Storing and recalling a value from MySQL
Hi Folks,
I have a form which succesfully stores data to MySQL.
In the handicap selct box varous vallues have been set rangeing from +3 to 36. This information is important to presentation and calculations later.
The problem that I have is that when the values +3, +2, +1 are selected on the form they are stored in MySQL as 3, 2 and 1 respectively.
I would accept then that the Structure needs to be then set correctly in terms of the TYPE (Numeric types)
I do not have knowledge on how to do this and if this well be the challenge , I ask that someone please advise?
If I am totally wrong in my assumption - please advise?
I have a form which succesfully stores data to MySQL.
In the handicap selct box varous vallues have been set rangeing from +3 to 36. This information is important to presentation and calculations later.
The problem that I have is that when the values +3, +2, +1 are selected on the form they are stored in MySQL as 3, 2 and 1 respectively.
I would accept then that the Structure needs to be then set correctly in terms of the TYPE (Numeric types)
I do not have knowledge on how to do this and if this well be the challenge , I ask that someone please advise?
If I am totally wrong in my assumption - please advise?
Comment