- 1
- 2
- 3
- 4
- 5
- 6
- 7
$proposal['categories'] = explode(',',db_get_field('
SELECT GROUP_CONCAT(pc.category_id)
FROM `?:proposal_categories` pc
INNER JOIN `?:proposal` p ON pc.`proposal_id` = p.`id`
INNER JOIN `?:proposal_category` pca ON pc.`category_id` = pca.`id`
WHERE pca.`status` = ?s AND pc.`proposal_id` = ?i
ORDER BY pca.position', 'A', $proposal['proposal_id']));