[Resolved] Combining multiple SELECT queries...

[ExpendableDecoy]

Hi. 🙂

I'm currently trying to save on a whole lot of code within my script because there are far too many SELECT queries that I'm sure can be made shorter.

What I'm wondering is can the following two statements be combined into one?.

// Grab rank 1
$sql = " SELECT character_name FROM db_characters 
        LEFT JOIN db_guilds
        ON db_characters.character_id = db_guilds.guild_rank_1_id 
        WHERE db_guilds.guild_id = $guild_id ";
if( !($result = $db->sql_query($sql)) )
{
       message_die(GENERAL_ERROR, 'Could not query Guild table for Rank 1', '', __LINE__, __FILE__, $sql);
}
$rank_member_1 = $db->sql_fetchrow($result);



// Grab rank 2
$sql = " SELECT character_name FROM db_characters 
         LEFT JOIN db_guilds
         ON db_characters.character_id = db_guilds.guild_rank_2_id 
         WHERE db_guilds.guild_id = $guild_id ";
if( !($result = $db->sql_query($sql)) )
{
       message_die(GENERAL_ERROR, 'Could not query Guild table for Rank 2', '', __LINE__, __FILE__, $sql);
}
$rank_member_2 = $db->sql_fetchrow($result);

Is this possible?.

Thanks in advance. 🙂

[mrhappiness]

try

SELECT c.character_name 
FROM db_characters c
	LEFT JOIN db_guilds g ON c.character_id IN (g.guild_rank_1_id, g.guild_rank_2_id)
WHERE g.guild_id = $guild_id

you should get two rows

if that doesn't work try using OR instead of IN

btw: you sure you want to use LEFT JOIN and have the table with possible NULL values in your WHERE?

[ExpendableDecoy]

Thanks. 🙂