[Mysql + PHP] SOLVED

[LucasFerraz]

$playersonline = $SQL->query('select count(*) from players where online = 1;')->fetchAll();

How can I convert this array to a string?

Using ModernAAC

 

[averatec]

join, implode functions?

 

[djtuca]

Lucas,

Voce gostaria de uma query especifica?

 

[LucasFerraz]

I just want to know how much players online using ModernAAC

Quero saber quantos players tem online no momento usando ModernAAC

 

[averatec]

$playersonline = $SQL->query('select count(*) as count from players where online = 1;')->fetchAll();
//$playersonline['count']

 

[LucasFerraz]

$playersonline = $SQL->query('select count(*) as count from players where online = 1;')->fetchAll();
//$playersonline['count']

do not work, it keeps in blank

 

[averatec]

did u try to print comment?

$playersonline = $SQL->query('select count(*) as count from players where online = 1;')->fetch();
echo $playersonline['count'];

 

[LucasFerraz]

Solved

".$playersonline[0]['count']."