PHP + MySQL = select + var

[LucasFerraz]

Hello,
how can I show this var?

$gamecode = XXXXX-XXXXX--XXXXX-XXXXX;
$count = $SQL->query("select count(*) from gamecodes WHERE gamecode='.$gamecode.' AND alreadyused='N';");

echo $count;

Error:

Catchable fatal error: Object of class PDOStatement could not be converted to string in Gesiorpath\htdocs\pages\accountmanagement.php on line 677

 

[dragaoart]

Can you show that line 677 from accountmanagement.php ?

Is you var $gamecode inside quotes? $gamecode = "XXXXX-XXXXX--XXXXX-XXXXX";

You may also need to fetch the results:

$query = "SELECT count(*) FROM `gamecodes` WHERE gamecode='".$gamecode."' AND alreadyused='N'";
$result = $SQL->prepare($query);
$result->execute();
$number_of_rows = $result->fetchColumn();

echo $number_of_rows;

 

[LucasFerraz]

Thanks