my $sql = 'UPDATE category SET name=? AND view_cats_prod=? AND description=? WHERE id=?'

my $y;
if (param('page') eq "yes") {
    $y = 'yes';
} else {
    $y = 'no';
}

$dbh->do($sql, undef, $cat, $y, $des, $id) ||
    die $dbh->errstr;