I\'m having troubles getting some records to update in the MySQL database.
As soon as you change the values to all numeric nothing will update. I have 4 fields (ID, model, serial, and location). Each is set to submit as the following:
ID: Integer (primary key)
model: Text
serial: Text
location: Text
In the database columns are set as:
ID: INT (NOT_NULL) Primary
model: TEXT (NOT_NULL)
serial: TEXT (NOT_NULL)
location: LONGTEXT (NOT_NULL)
All the updating works fine as long as you keep all fields alphanumeric, as soon as you change one to strictly numeric after that nothing will update.
I can\'t figure this out and I\'m new to PHP/MySQL.
Please help.
Thanks.