select
category_id,
category_type,
short_name,
description
from
rl_resource_category
where
category_id = :category_id
select
short_name,
category_id as my_cat_id
from
rl_resource_category_type
UPDATE
rl_resource_category
SET
category_type = :category_type,
short_name = :short_name,
description = :description
WHERE
category_id = :category_id
insert into
rl_resource_category
(category_id, category_type, short_name, description)
values
(:category_id, :category_type, :short_name, :description)