Joomla PHP Query - Joomla! Forum - community, help and support


hi all,

i'm trying write query pull information database, isn't liking second clause.

$query = $db->getquery(true);

$query
->select($db->quotename(array('pid','fullname')))
->from($db->quotename('#__member_info'))
->where($db->quotename('organization').' = '.$db->quote($schoolname))
->where($db->quotename('paid').' = '. "n");

not sure i'm doing wrong, appreciated! :)

try this:

code: select all

->where($db->quotename('paid').' = '.$db->quote('n'));





Comments

Popular posts from this blog

Falang and too many redirects - Joomla! Forum - community, help and support

Infinite loop detected in JErrorInfinite loop detected in JError - Joomla! Forum - community, help and support

logged out from joomla! - Joomla! Forum - community, help and support