specific users

Got2010ggd 13 Oct, 2008
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?
Max_admin 13 Oct, 2008
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
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.