Support » Plugin: EZ SQL Reports Shortcode Widget and DB Backup » limit report by loginname

  • Resolved onyxtacular

    (@onyxtacular)


    Love the plugin. I’ve got a report I want to limit but the current user login. I just can’t seem to get the syntax correct.

    Select * from tablename where CustomerID = ‘ . $current_user->user_login . ‘

    Please and Thank you.

Viewing 1 replies (of 1 total)
  • Found it listed here….just had to read through a few more pages:

    select * FROM ‘tablename’ where CustomerID = <?php $current_user->user_login ?>

    ty

Viewing 1 replies (of 1 total)
  • The topic ‘limit report by loginname’ is closed to new replies.