in reply to Somethings not rightwith my MySQL do()
You've got the UPDATE syntax wrong, it should be like:
UPDATE category SET name = ?, view_cats_prod = 'yes' WHERE id = ?
You should really test your SQL statements before you put them into your perl code.
In Section
Seekers of Perl Wisdom