This issue is more of a MySQL issue than php. I am trying to store a 5 digit integer and a 9 character varchar field in a table. Both have to be able to take values with a leading zero such as 02130 or 089fg7agf.
I am successfully storing the data however the stored data loses the zero at the beginning in both cases. I thought about perhaps using a float data type, however for the varchar value that wouldn't work...
any suggestions are greatly appreciated.