Pull MySQL data from multiple tables and merge into 1 PHP array

Apparently both wattp_users and wattp2_as_score tables have a column named score_as.

Put a prefix with the table name before every mention to score_as column, just as you did with the ID (e.g. wattp2_users.ID) to avoid beeing ambiguous.

Related Posts:

  1. Transaction when using WP functions rather than vanilla SQL?
  2. How to get the list of WooCommerce product image of a certain category from database?
  3. How to make WordPress plugin check for database changes and then do something?
  4. How to Join two tables from separate databases within WordPress
  5. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  6. register_activation_hook isn’t adding table to DB
  7. What SQL / WordPress queries would need a nonce?
  8. Importing Geo data into wordpress database
  9. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  10. $wpdb->insert() does not Insert record in a table
  11. Use $wpdb or other PHP script method to find/replace in WP database
  12. How can I add a new row in a separate database when someone registers via WordPress?
  13. Use variable in SQL statement
  14. mySQL queries are executed twice on wordpress website
  15. making php value numeric
  16. Database SQL query error
  17. How to run complex query using PHP
  18. Inserting other fields to existing registration form in a WordPress theme
  19. SQL Query Search page
  20. can’t delete a row from post_meta table
  21. Conditional statement within WP SQL query
  22. How to properly prepare a column name if passed to a stored procedure?
  23. inserting a post from an extern php file but post content doesn’t show on wp site
  24. Database query works fine outside WordPress
  25. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  26. $wpdb->wp_users returning empty value for
  27. Genesis framework comments broken?
  28. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  29. Using custom tables for old posts
  30. Databases – Submitting data from inputs to database [closed]
  31. Help with a $wpdb MySQL Query
  32. WordPress SQL injection
  33. Not connecting to database in file with multiple MySQL connections
  34. Way to bulk make all my tags lowercase?
  35. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  36. How i can obtain all the post meta for a specific post as an array?
  37. multiple where condition in result query
  38. Grouping posts by a custom meta value
  39. Multiple meta_key in one global $wpdb;
  40. Custom array from a query only write the last row of the query
  41. WordPress member notification
  42. Is it best to avoid using $wpdb for security issues?
  43. Can’t Query Custom Table Using $wpdb Method
  44. Moving wordpress site from localhost to live server using GoDaddy cPanel
  45. How does WP work in conjunction with a web server?
  46. WordPress Block developer from exporting Database via PHP
  47. $wpdb returns duplicate posts
  48. Update postmeta after theme switch
  49. Mixing variables into an array when inserting values
  50. Location of core code for database connection and get_header
  51. wpdb prepare insert table doesn’t work
  52. Should I use WordPress to skin a database website?
  53. php include not working in custom page
  54. How do I display offsite database info on my wordpress site?
  55. Creating Database Table vs. Adding MetaData to Post & User
  56. Make a database query using WordPress
  57. Force Users To Relogin
  58. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  59. dynamic page using php from sql database
  60. WordPress Custom SQL Table with UserID Filter for results
  61. Most commented posts by time period (last 12h, last 24h and etc)
  62. email alert for product availability
  63. How to Update post_modified of all wordpress post
  64. Correct PHP to output a single result of a Function with SQL Query
  65. Issue with fetching mysql data and displaying results via shortcode in webpage
  66. Basic wpdb update question
  67. Hide posts if user is added to it WP_query
  68. I can’t update my data through $wpdb
  69. A $_POST should occur when submit form but is not?
  70. Custom route and query
  71. Output: “Array”
  72. How to unserialize data from MySQL
  73. How to use mysql LIKE with wpdb?
  74. PHP -> SQL Query with Summing
  75. Lost in trying to create user database system
  76. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  77. WordPress WP_Query without query GET parameters
  78. How do I prepare strings for insertions as values into a MySQL table?
  79. Filter results from a serialized string to use on statistics
  80. Known Issues in WordPress When Upgrading PHP to ver 7
  81. Using CFDB7 vs Custom MySQL Database [closed]
  82. wordpress site – using custom database and PHP
  83. How to use AJAX in WordPress in MYSQL query?
  84. add category to posts with tag wordpress
  85. Searching Posts Programmatically in a WordPress Plugin
  86. How can I Use 2 databases with one WordPress install
  87. Using wordpress function to retrieve data
  88. Live search from database table
  89. Processing ajax call to php to insert into mysql database
  90. Edit Account – read and write to MySQL
  91. form $_post action value gets truncated after it passes through two forms
  92. Why my query does not run with prepare
  93. Get the id of the row from database on click of a button [closed]
  94. Why won’t this wpdb get_results query return results?
  95. WPDB secure custom form
  96. Why when I create a new post I found 2 record related to this post into the posts database table?
  97. Adding data to custom wordpress database table
  98. wpdb getting avatars and author url
  99. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  100. Add row to custom database Table and delete all rows older than 1 day
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)