IF select this, ELSE select that

[scarhand]

You'll be able to see what I'm trying to do:

 

$sql = $db->query("select s.*, u.displaygroupid as did, 
                   if(did = 0, u.usergroupid as gid, u.displaygroupid as gid)
                   (select opentag from " . TABLE_PREFIX . "usergroup where usergroupid = gid) as opentag,
                   (select closetag from " . TABLE_PREFIX . "usergroup where usergroupid = gid) as closetag
                   from " . TABLE_PREFIX . "shoutbox as s, " . TABLE_PREFIX . "user as u
                   order by id desc limit " . $vbulletin->options['ddsb_show'] . "");

 

Doesn't work. Can someone show me the proper way of writing this query?

[Maq]

You'll be able to see what I'm trying to do:

 

Not really...

 

How doesn't it work?  Does it throw any errors?

[fenway]

Alias the expression instead:

 

if(did = 0, u.usergroupid as gid, u.displaygroupid as gid)

 

becomes

 

if(did = 0, u.usergroupid, u.displaygroupid) as gid