[RESOLVED] Query works in NaviCat but not PHP?

[dbrown]

Hi everyone,

I've read and learned a lot at PHP Builder, so first let me say thanks for that 🙂

My problem is that I do fine with standard (simple) database inquiries, but I'm failing horribly with things like joins.

Can anyone help me understand why this query (less the $query and quotes of course) works in Navicat 8 but not in PHP? Same test server, hitting the same database, with the same tables/data.

Of course, some guidance on how to format this properly for PHP would be greatly appreciated.

$query = "
SELECT T.typeid, T.groupID, T.typename, T.description, T.graphicID, G.GroupID, G.categoryID 
	FROM invTypes T 
		INNER JOIN invGroups G ON T.GroupID = G.GroupID 
	WHERE T.published = 1
		AND G.categoryID != 9
		AND T.typename 
        LIKE 'burner'
	ORDER BY T.typename";

In case server information is helpful -

Apache: 2.2.8
PHP: 5.2.6
MySQL: 5.0.51B
PHP Extension: mysqli

[YAOMK]

You may want to enclose the names of your tables and fields with back ticks. See Schema Object Names in the manual for more information. If the problem persist, try to retrieve the mysql_error().

[dbrown]

Many thanks Yaomk! That helped resolve my issue 🙂