Forums

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 :

WHERE userid='<?php $user = JFactory::getUser(); echo $user->id; ?>'

in the WHERE SQL box.

Cheers,

Max

Thanks worked great!