无法使查询与变量一起工作

Question

i have this query

AND i.state = 1
AND i.language = "'.$mylang.'"
AND i.access IN ('.implode(',', $user->getAuthorisedViewLevels()).')

i should get the content only for the current language) the strange thing is that with the php variable $mylang it's not working ( writing it-IT ) i get the content. I allready checked the result of $mylang and its = to it-IT .

any clues? thanks.

Answer 1

I'm not sure about the 1=1 subclause in your WHERE but ignoring that Try something like this:

$db = JFactory::getDBO();
$query = $db->query(true);
$query->select('i.*')
    ->from($db->quteName('#__content')) 
    ->where($db->quoteName('i.state') . ' = 1')
    ->where($db->quoteName('i.language') .' = '  $db->quote($mylanguage))
    ->where($db->quoteName('i.access') . ' IN (' . impode(',',$user->getAuthorisedViewLevels()) . ')' )
 ...
;
$db->set($query);
....

Also, if your queries are not working the best thing is to do echo $query->dump() to see the rendered query, also you can just look at the queries if you turn the debugger on.