Title: Mapping Database User ID between WordPress and Learnpress
Last modified: December 30, 2021

---

# Mapping Database User ID between WordPress and Learnpress

 *  [MatzJB](https://wordpress.org/support/users/matzjb/)
 * (@matzjb)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/mapping-database-user-id-between-wordpress-and-learnpress/)
 * I’m a noob at databases, so I need some help. I want to understand how the user_id
   in WordPress is mapped to the learnpress user_id.
    When I am looking at the data
   in the table ‘wp_users’ I see (ID, user_login, user_pass,…) the ID range is between
   1 and 36.
 * If I look at ‘learnpress_user_item_results’ we have (ID, user_item_id, result)
   
   now here the ID range is 1 to 21, so the ID in wp_users and this table is not
   representing the same ID.
 * My question is, how can I figure out what learnpress ID corresponds with what
   wordpress ID?

Viewing 1 replies (of 1 total)

 *  Plugin Support [brianvu-tp](https://wordpress.org/support/users/briantp/)
 * (@briantp)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/mapping-database-user-id-between-wordpress-and-learnpress/#post-15208501)
 * Hi,
 * Table “learnpress_user_item_results” will save results users are learning or 
   finished course, it joins to table “learnpress_user_items” via “user_item_id”
   to know user_id and course_id, So if you want to map user_id of WP with user_id
   of LP you need to use clause to join SQL
 * Thanks

Viewing 1 replies (of 1 total)

The topic ‘Mapping Database User ID between WordPress and Learnpress’ is closed 
to new replies.

 * ![](https://ps.w.org/learnpress/assets/icon-256x256.gif?rev=3254420)
 * [LearnPress - WordPress LMS Plugin for Create and Sell Online Courses](https://wordpress.org/plugins/learnpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/learnpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/learnpress/)
 * [Active Topics](https://wordpress.org/support/plugin/learnpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/learnpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/learnpress/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 1 reply
 * 2 participants
 * Last reply from: [brianvu-tp](https://wordpress.org/support/users/briantp/)
 * Last activity: [4 years, 5 months ago](https://wordpress.org/support/topic/mapping-database-user-id-between-wordpress-and-learnpress/#post-15208501)
 * Status: not resolved