I have a table (tasks) with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the row (using the pencil icon=Edit)