osCommerce: How do i change the 'quantity' field from only allowing numbers to all characters?

264 Views Asked by At

Is it something in MySQL or in the programming...cant figure it out!!

1

There are 1 best solutions below

1
On

in the mysql table the Quantity is set to an "int" data type. you can alter the table and change it to a "varchar" data type and that would allow you to have letters in there as well.

try something like this:

ALTER TABLE t1 CHANGE quantity quantity VARCHAR(255);