I'm trying to get data for the current user by adding the userID variable, but it returns no text when I add the bold content below. Is my syntax off? The query works fine in the module without this addition (copied from another module).

SELECT week_number, company, division, department, firstname, middlename, lastname, suffix, homephone, cell_number, total_point
FROM jos_users, jos_employee, jos_employee_data
WHERE jos_employee.username=jos_users.username AND jos_users.id=jos_employee_data.userid AND jos_employee_data.total_point>34 AND UserID = {$UserID}
ORDER BY jos_employee_data.total_point DESC, jos_employee.lastname ASC

Thanks

Hello,

Try to use the following code:



instead of your code:



Regards,
ARI Soft

Great idea, but it didn't work.

Set "SQL -> Debug" parameter to "Yes" and check that the query doesn't contain error(s).

If it doesn't help, send SQL dump of the tables which are used in the query by email so we can investigate the problem or provide a temporary access to your J! backend and a link to a page where we can see the problem by email.

Regards,
ARI Soft