Solved Weird error in php query

[Nekiro]

Hello, I cannot get this to work.

I'm using gesior.

What I'm trying?

I'm trying to get "players_record" value into variable.

$record = $SQL->query("SELECT `value` FROM `server_config` WHERE `config` = players_record");
echo $record;

It's showing nothing... When I try:

$record = $SQL->query("SELECT `value` FROM `server_config` WHERE `config` = 'players_record'");
echo $record;

The site fail to load.

 

[Danger II]

$record = $SQL->query("SELECT * FROM `server_config` WHERE `config` = 'players_record'")->fetch();
echo $record['value'];

 

[Nekiro]

Thank you works.

Could you explain why my didnt work and yours work?

 

[Ziker]

Simply? Because you didn't fetch the data. I'm not sure where this come from, but I can only assume that your

$SQL->query(...);

returns an SQL statement, not its result.