I posted this problem some time ago and failed to get it resolved.
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 'SQL: WHERE 'cf_user_id' = 63' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_SchoolDetails WHERE SQL: WHERE 'cf_user_id' = 63
Can some please help to resolve this?
Cheers
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 'SQL: WHERE 'cf_user_id' = 63' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_SchoolDetails WHERE SQL: WHERE 'cf_user_id' = 63
WHERE SQL:
<?php
$user = &JFactory::getUser();
echo "WHERE 'cf_user_id' = ".$user->id
?>
Can some please help to resolve this?
Cheers