If empty then a message PHP

[president vankk]

Hello everyone, so.. I'm having some problems with the code below.
I want if case 1 is empty, then echo 'No war.';

Just that, how I do that?

$war:

foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` WHERE `guild1` = ' . $guild_id . ' OR `guild2` = ' . $guild_id . ' ORDER BY CASE `status` WHEN 0 THEN 2 WHEN 1 THEN 1 WHEN 4 THEN 3 WHEN 3 THEN 4 WHEN 2 THEN 5 END, `started` DESC') as $war)

switch($war['status'])
{
   case 1:
   {
     ECHO '<table class="table table-striped">
     <thead>
     <tr>
     <th>Description</th>
     <th style="width:25%">Started</th>
     <th style="width:12%">Stats</th>
     <th style="width:10%">Details</th>
     </tr>
     </thead>
     <tbody>
     <tr><td>
    
     <a href="guilds&action=show&guild='.$war['guild1'].'">'.htmlspecialchars($war['name1']).'</a>
     are at war against
     <a href="guilds&action=show&guild='.$war['guild2'].'">'.htmlspecialchars($war['name2']).'</a>.</td>
    
     <td>' . date('M d Y, H:i:s', $war['started']) . '</td>
    
     <td>
     <strong>' . $war['guild1_kills'] . '</strong>
     -
     <strong>' . $war['guild2_kills'] . '</strong></td>
    
     <td><a class="btn btn-info btn-mini" href="guildwar.php?id='.htmlspecialchars($war['id']).'">View</a></td>
    
     </tr></tbody>
     </table>';
   }
}

Thanks.

 

[Emky]

switch($war['status']) {
    case 1: echo "your table stuff here"; break;
    default: echo "No War."; break;
}

or maby surround it with an if statement, like

if(empty($war['status'])) {
    echo "no war";
} else {
  ....switch case stuff
}

 

[president vankk]

Guild with warmode

Guild without warmode:

ECHO '<div class="tab-pane" id="tab2">
       <table class="table table-striped">
       <thead><tr>
       <th>Description</th>
       <th style="width:25%">Started</th>
       <th style="width:12%">Stats</th>
       <th style="width:10%">Details</th></tr></thead>';
       
       $count = 0;
       foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` WHERE `guild1` = ' . $guild_id . ' OR `guild2` = ' . $guild_id . ' ORDER BY CASE `status` WHEN 0 THEN 2 WHEN 1 THEN 1 WHEN 4 THEN 3 WHEN 3 THEN 4 WHEN 2 THEN 5 END, `started` DESC') as $war)
       {
         $count++;
         if(in_array($war['status'], array(1)))
           {
             ECHO '<tbody><tr><td>
             <a href="guilds&action=show&guild='.$war['guild1'].'">'.htmlspecialchars($war['name1']).'</a>
             are at war against
             <a href="guilds&action=show&guild='.$war['guild2'].'">'.htmlspecialchars($war['name2']).'</a>.</td>
             <td>' . date('M d Y, H:i:s', $war['started']) . '</td>
             <td>
             <strong>' . $war['guild1_kills'] . '</strong> - <strong>' . $war['guild2_kills'] . '</strong></td>
             <td><a class="btn btn-info btn-mini" href="guildwar.php">View</a></td>';
           } else {
            echo '<tr><td colspan="4">'.$guild_name.' are not participating in any war at the moment.</td></tr></tbody>';
           }
       }
     
       ECHO '</tr></tbody></table></div>'; # END ACTIVE WARS