I made a report using the tutorial and it is bringing everything up that is is the database. Is there any place to get the code to have the report just pick the items of the user that is loged in?
Hi, if your table has a column called "useid" for example which has the user id set for this record then you can write this :
in the WHERE SQL box.
Cheers,
Max
WHERE userid='<?php $user = JFactory::getUser(); echo $user->id; ?>'
in the WHERE SQL box.
Cheers,
Max
Thanks worked great!
This topic is locked and no more replies can be posted.