[SQL/PHP] non-object problem (Phones off)

[ExibeR]

2 scripts and 2 errors, just the way a computer should work.

I have 1 problem on each script, both scripts should work.
It's php btw, and I'm using Gesior and TFS 0.3.2

.php:

Fatal error: Call to a member function query() on a non-object in

Inside:

$wars = $SQL->query("

Same error in both scripts, so the problem is with the $SQL->query

Tables are added to database as well.

 

[Norix]

Please post he hole $wars line...

 

[ExibeR]

Please post he hole $wars line...

$wars = $SQL->query("
	SELECT g.name AS gname, wg.name AS wgname, g.war_time AS gtime, g.kills AS kills, wg.kills AS ekills, g.show AS s, g.id AS gid
		FROM guilds AS g
	INNER JOIN guilds AS wg
		ON wg.id = g.in_war_with
	ORDER BY s DESC LIMIT 50;
");

 

[Norix]

maybe try adding this at the end:

->fetch();

so:

$wars = $SQL->query('
    SELECT g.name AS gname, wg.name AS wgname, g.war_time AS gtime, g.kills AS kills, wg.kills AS ekills, g.show AS s, g.id AS gid
        FROM guilds AS g
    INNER JOIN guilds AS wg
        ON wg.id = g.in_war_with
    ORDER BY s DESC LIMIT 50;
')->fetch();

 

[ExibeR]

maybe try adding this at the end:

->fetch();

so:

$wars = $SQL->query('
    SELECT g.name AS gname, wg.name AS wgname, g.war_time AS gtime, g.kills AS kills, wg.kills AS ekills, g.show AS s, g.id AS gid
        FROM guilds AS g
    INNER JOIN guilds AS wg
        ON wg.id = g.in_war_with
    ORDER BY s DESC LIMIT 50;
')->fetch();

Didn't work. It disabled some text, and just gave me new errors.

 

[ExibeR]

~bump~