Hello,
I use joomla 2.5.27 and community builder 2.0.2.
I use cb rank plugin for community builder , it work fine but now I get error
I get error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `confirmed` = 1 AND `approved` = 1' at line 1 SQL=SELECT COUNT(`id`) FROM r2yze_comprofiler WHERE `cb_points` > AND `confirmed` = 1 AND `approved` = 1
php code
Code:
// Calculate rank
if ( $ordertype == "low" ) {
$_CB_database->setQuery( "SELECT COUNT(`id`) FROM #__comprofiler WHERE `$fieldname` < $userfield AND `confirmed` = 1 AND `approved` = 1" );
}
else {
$_CB_database->setQuery( "SELECT COUNT(`id`) FROM #__comprofiler WHERE `$fieldname` > $userfield AND `confirmed` = 1 AND `approved` = 1" );
}
$value = $_CB_database->loadResult() + 1;
How I can solve this error
thank you.
nant