$here = " && ltcolor='rotor'";
$where=" && make='Canada'";
I have query something like this
$querytotal="SELECT mempages.rtcolor, mempages.ltcolor, mempages.memid, mempages.bgimg, vehicle.make, vehicle.model, vehicle.year, count (*)
FROM mempages INNER JOIN vehicle ON (mempages.memid = vehicle.memid) where mempages.bgimg!=''".$here.$where;
and I get this error :
'EXOTIC'Error 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(*) FROM mempages INNER JOIN vehicle ON (mempages.memid = veh
Question: is count(*) allowed in this kind of query?
