Stored Procedure or complex sql statement

14 years 7 months ago #106663 by Goldarm12
What sytax should be used for a complex sql statement?
I have a cb dropdown field that controls the event id for event registration.

Here is what I have.

DELIMITER //
CREATE PROCEDURE YouthCampReg()
CASE
WHEN [cb_youthcamps] = 'VA Youth Camp' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 2)
WHEN [cb_youthcamps] = 'NC Youth Camp' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 3)
WHEN [cb_youthcamps] = 'NY Youth Camp 1' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 4)
WHEN [cb_youthcamps] = 'NY Youth Camp 2' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 5)
WHEN [cb_youthcamps] = 'MA Youth Camp' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 6)
WHEN [cb_youthcamps] = 'ME Youth Camp' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 7)
WHEN [cb_youthcamps] = 'PA Youth Camp' THEN
INSERT INTO `jos_eventlist_register` (`uid`, `event`) VALUES ([user_id], 8)
END CASE;
END //
DELIMITER ;

Any help will be greatly appreciated.

Best,
Don

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.190 seconds

Facebook Twitter LinkedIn