Should I use an additional column in the DB?

WordPress already has both user and post meta data tables, and associated API for handling the data. Storing an array of post IDs for each user in user meta sounds like it would work for your application.

Related Posts:

  1. WordPress Unit Testing – Cannot Create Tables
  2. Using wpdb to connect to a separate database
  3. WPDB Insert or if exists Update
  4. Is it mandatory to use $wpdb->prefix in custom tables
  5. get_results using wpdb
  6. $wpdb won’t insert NULL into table column
  7. Get error messages when $wpdb->insert() returns false?
  8. Detecting errors generated by $wpdb->get_results()
  9. Does dbDelta delete columns as well?
  10. wpdb update add current timestamp not working
  11. How to fetch Data in WordPress using MySQLi or $wpdb
  12. wpdb->insert multiple record at once
  13. How to define composite keys with dbDelta()
  14. Insert data in database using form
  15. Does wpdb add considerable overhead on queries with large result sets?
  16. Why does $wpdb return strings for mysql integer values?
  17. $wpdb->prepare() warning in WordPress 3.5
  18. When is it appropriate to create a new table in the WordPress database?
  19. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  20. Inserting data into custom tables
  21. Hook into $wpdb
  22. Display data from a non wordpress database on a page template
  23. How does $wpdb handle COUNT(*)
  24. How might I retrieve a featured post image from an external WP site and display it as a link back?
  25. WordPress database error: [Query was empty] [closed]
  26. Export wordpress table to excel
  27. How to close wpdb connection? [duplicate]
  28. Inserting Post Meta From SQL
  29. Why does dbDelta() not catch MysqlErrors?
  30. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  31. Connecting to external oracle database
  32. Can’t save ajax value to database
  33. What causes the “max_user_connections” warning on WordPress frontend?
  34. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  35. Updating all rows of table with $wpdb
  36. Safe way to find last inserted id in a table?
  37. How to execute mulitple statement SQL queries using $wpdb->query?
  38. stdObject stored in database. How does one convert it to usable format?
  39. Is $wpdb->prepare escaping to much? How to use it properly?
  40. Database slowdown after update to 3.4.1
  41. When and why should I use $wpdb different return types?
  42. Database with mixed collation (utf8mb4 & utf8_general_ci)
  43. How wordpress accesses its own database
  44. Remove database entries where post_date > expiration date
  45. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  46. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  47. Get data from database using $WPDB
  48. How to use a different database to list and manage comments in the backend
  49. Getting all the users who have author privilege
  50. Multiple postmeta with same name for one post in wp_postmeta table
  51. WP Database Table to CSV file
  52. Cannot update custom database table row
  53. wpdb_prepare with multiple or condition
  54. Show last modified date of database
  55. $wpdb->insert is not working
  56. Moving to another host; which tables to move in a database
  57. WordPress mysql table double prefixes
  58. Extracting the post_id via the wp_insert_post action (external db query)
  59. WordPress database error – Error in SQL syntax – I can’t identify any error?
  60. In what part of the WordPress core does the users table and usermeta table get joined?
  61. Modify Database in Multi-Site wp_usermeta table
  62. Change WordPress prefix for only one table?
  63. Multiple wp_options tables to share content across installs
  64. Advanced SELECT query with condtional statements
  65. $wpdb doesn’t like to store arrays
  66. Select two sums with single get_var statement
  67. WordPress choose wrong database
  68. input data and output table [closed]
  69. Redirecting to old domain after migration website
  70. Retrieve data from the database to table such as comments in the admin control panel
  71. Create table from array with prepare
  72. Update from 4.5 to 4.6 failing
  73. Does WordPress $wpdb functions wait when table is locked?
  74. Create a table with wordpress plugin boilerplate
  75. How Can I Put Meta_Compare in the Database-Query?
  76. WordPress running SQL query to update database from form
  77. $wpdb->insert Giving duplicates
  78. How to access custom WordPress database tables
  79. Change options table prefix only
  80. I’m not able to get access to $wpdb [duplicate]
  81. WPDB SQL query with prepare() returning variable, not db value
  82. Query multiple tables at once?
  83. $wpdb error (Call to a member function insert() on a non-object)
  84. Have working sql query… trying to adjust it to use $wpdb
  85. Is it important to have integers inserted using %d rather than %s?
  86. Problem in using wpdb
  87. $wpdb->query can’t insert data
  88. Custom WordPress Table wpdb
  89. How to fetch records from database WordPress
  90. Best practice to limit results in get_row()?
  91. Best practice to import user base (subscribers) from one website to another?
  92. AJAX wp-mysql running too slow
  93. CreateOrUpdate in WordPress
  94. Problem migrating to localhost
  95. Clear Terms from Taxonomy for Specific Post IDs?
  96. Why does changing Database Table Prefixes result in loss of content?
  97. Trouble running $wpdb->query() with last_insert_id
  98. How to get a list of WordPress default database tables?
  99. Connecting to a different database
  100. Using $wpdb | checking entered email against existing emails in db
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)