[RESOLVED] IF/ELSE with two arguments each

[mrbaseball34]

I can't seem to get my head around why I cannot do this:

SELECT
  ..,
  ..,
  IF (e.SeatsAreAvailable < 1) AND (ISNULL(e.LicenseeURL)) THEN
    CONCAT('<a href="',
           CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
           '" >View Details</a> | ',
           '<a href="javascript:void(0);" rel="obl" class="popup1 red_btn" id="course',
           e.EventCode,
           '" title="Click here to be placed on waiting list." >Wait List*</a>') as Information
  ELSEIF (e.SeatsAreAvailable < 20) AND (ISNULL(e.LicenseeURL)) THEN
    CONCAT('<a href="',CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
           '" >View Details</a> | ',
           '<a href="javascript:void(0);" rel="obl" class="popup1 yellow_btn" id="course',
           e.EventCode,
           '" title="Register soon, less than 20 seats left!" >Limited Seats</a>') as Information
  ELSE 
    CONCAT('<a href="',CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
           '" >View Details</a> | ',
           '<a href="javascript:void(0);" rel="obl" class="popup1 register_btn" id="course',
           e.EventCode,
           '" title="Register" >Register</a>') as Information
FROM exp_course_events e 
INNER JOIN exp_channel_data d ON e.ProgramCode = d.field_id_41 
INNER JOIN exp_channel_data d2 ON d2.field_id_47 = d.field_id_48 
INNER JOIN exp_channel_titles t ON d.entry_id = t.entry_id 
INNER JOIN exp_channel_titles t2 ON t2.entry_id = d2.entry_id 
INNER JOIN exp_zip_lat_long zl ON zl.zip = e.LocZipCode 

Can I not use an IF here? How would I do this in MySQL?

[Lars_Berg]

No, use a case expression.

[mrbaseball34]

Yes, like this:

if((e.SeatsAreAvailable < 1) AND (ISNULL(e.LicenseeURL)),
  CONCAT('<a href=\"',
         CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
         '\">View Details</a> | ',
         '<a href=\"javascript:void(0);\" rel=\"obl\" class=\"popup1 red_btn\" id=\"course',
         e.EventCode,
         '\" title=\"Click here to be placed on waiting list.\" >Wait List*</a>',
         '<input id=\"price', e.eventCode, '\" value=\"', e.Price, '\" type=\"hidden\">
         <input id=\"licenseeLink',e.eventCode, '\" value=\"null\" type=\"hidden\">
         <input id=\"eventid',e.eventCode,'\" value=\"',e.eventCode,'\" type=\"hidden\">
         <input id=\"gk_',e.eventCode,'\" value=\"',e.GateKeeper_length,'\" type=\"hidden\">'),
  if((e.SeatsAreAvailable < 20) AND (ISNULL(e.LicenseeURL)),
  CONCAT('<a href=\"',CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
         '\">View Details</a> | ',
         '<a href=\"javascript:void(0);\" rel=\"obl\" class=\"popup1 yellow_btn\" id=\"course',
         e.EventCode,
         '\" title=\"Register soon, less than 20 seats left!\" >Limited Seats</a>',
         '<input id=\"price', e.eventCode, '\" value=\"', e.Price, '\" type=\"hidden\">
         <input id=\"licenseeLink',e.eventCode, '\" value=\"null\" type=\"hidden\">
         <input id=\"eventid',e.eventCode,'\" value=\"',e.eventCode,'\" type=\"hidden\">
         <input id=\"gk_',e.eventCode,'\" value=\"',e.GateKeeper_length,'\" type=\"hidden\">'),
  CONCAT('<a href=\"',CONCAT('/courses/', d.field_id_48, '/', t.url_title, '/', e.EventCode),
         '\">View Details</a> | ',
         '<a href=\"javascript:void(0);\" rel=\"obl\" class=\"popup1 register_btn\" id=\"course',
         e.EventCode,
         '\" title=\"Register\">Register</a>',
         '<input id=\"price', e.eventCode, '\" value=\"', e.Price, '\" type=\"hidden\">
         <input id=\"licenseeLink',e.eventCode, '\" value=\"null\" type=\"hidden\">
         <input id=\"eventid',e.eventCode,'\" value=\"',e.eventCode,'\" type=\"hidden\">
         <input id=\"gk_',e.eventCode,'\" value=\"',e.GateKeeper_length,'\" type=\"hidden\">') 
)) as Information,