PHP - Get guild_id

[Vincent]

Hello,

i create at the moment a own Flux Addon.

So at the moment i need the guild_ids from the acc that are atm logged to flux.

For some reason the array is empty.

 

Any idea how to fix it?

 

Here my code:

$sql = "SELECT guild_id FROM {$server->charMapDatabase}.char WHERE account_id = 2000000";
$sth = $server->connection->getStatement($sql);
$guild = $sth->fetchAll();		

Edited August 25, 2014 by Vincent

[Vincent]

Try using fetch(); instead of fetchAll();

if i change it to fetch() the array is filled with "bool(false)"

[Vincent]

Thanks it works.