[TFS 1.2] Cast website

[president vankk]

Hi everyone, I'm using djarek's cast system and I'm having a problem to how many casts are online and how many spectadors does it have.

I'm using the code below and having this problem:

$cast = $SQL->query('SELECT COUNT(*) FROM `live_casts` WHERE `player_id`>0;')->fetch();
     $spectators = $SQL->query('SELECT SUM(`spectators`) FROM `live_casts`;')->fetch();

<strong><?php echo ' '.$cast[0].''; ?></strong> cast online with <strong><?php echo ' '.$spectators[0].''; ?></strong> spectators.

Thanks.

 

[Ninja]

SUM returns NULL when there are no rows in a table. However you can use IFNULL or COALESCE around SUM to return 0 instead of NULL.

IFNULL(SUM(`spectators`), 0) -- Returns the first expression if it's a non-NULL value, otherwise it will return the second expression.

COALESCE(SUM(`spectators`), ...) -- Returns the first non-NULL value in the list, or NULL if there are no non-NULL values.

 

[president vankk]

@Ninja
Thanks!!