Hello, iam trying to start with my custom PHP-Script in Amember. PHP: $location = Am_Di::getInstance()->db->select("SELECT * FROM _requests WHERE lon ='?' AND lat ='?' LIMIT 1", '33.4550','12.4550'); For that simple SQL statment iam getting an empty output array. This can not be, because this Solution is working PHP: $location = Am_Di::getInstance()->db->select("SELECT * FROM _requests WHERE lon ='33.4550' AND lat ='12.4550' LIMIT 1"); Is there a Debug Mode to output the generated Statement?
Syntax is incorrect. Use this instead: PHP: $location = Am_Di::getInstance()->db->select("SELECT * FROM _requests WHERE lon =? AND lat =? LIMIT 1", '33.4550','12.4550');
Not working. this was of course my first try. Thats why i need a SQL output of the rendered SQL - Debug