Hi guys. I need some help with a damn sql query that I can't seem to make it work. It should be easy, but I just can't figure out what I'm doing wrong.
So, I have a table with a few columns that is editable by users on the front-end. Each user sees only his entries. The first column is the user's ID (I'm on Wordpress, by the way). Next, I'm trying to do a query that will pull all the data submitted by users and output it into a "public" table. Everything is fine, except that I want the table to show the user's name instead of the ID. I've read a little and it seems I can do this with a INNER JOIN on that query, but I can't get it to work, I constantly get sql statement errors when trying to save the damn thing. Somehow I need to link the user_nicename column from wp_users to the ID column and output the name instead of the id.
Any help? Thank you!
P.S. Here's how my query looks like, and it doesn't work (the JOIN part):
SELECT wp_table_1.userID,
wp_table_1.date,
wp_table_1.name,
wp_table_1.input1,
wp_table_1.input2,
FROM wp_table_1
SELECT wp_users.user_nicename, wp_table_1.name
FROM wp_users
JOIN wp_table_1
ON wp_users.ID=wp_table_1.name
Indeed, it is. Doesn't mean we have to like it.
But at certain size you can make the "there is nowhere else to go to", ie see Apple/Google vs Epic Games lawsuit. Apple got struck down hard, even though you "can go elsewhere". Apple is 100% monopolistic on iOS though, Google is only 99% on Android, so I guess the comparison isn't exact.
But there's nothing illegal about it, that's the point. YouTube can be abusive with its policies, but they can always show you the door and you can always go to another platform. The problem is that everyone wants to be on YouTube. Think of YouTube as the Nvidia of video platforms.
Its sucks really hard, but it's the reality.
Question
TDT
Hi guys. I need some help with a damn sql query that I can't seem to make it work. It should be easy, but I just can't figure out what I'm doing wrong.
So, I have a table with a few columns that is editable by users on the front-end. Each user sees only his entries. The first column is the user's ID (I'm on Wordpress, by the way). Next, I'm trying to do a query that will pull all the data submitted by users and output it into a "public" table. Everything is fine, except that I want the table to show the user's name instead of the ID. I've read a little and it seems I can do this with a INNER JOIN on that query, but I can't get it to work, I constantly get sql statement errors when trying to save the damn thing. Somehow I need to link the user_nicename column from wp_users to the ID column and output the name instead of the id.
Any help? Thank you!
P.S. Here's how my query looks like, and it doesn't work (the JOIN part):
SELECT wp_table_1.userID, wp_table_1.date, wp_table_1.name, wp_table_1.input1, wp_table_1.input2, FROM wp_table_1 SELECT wp_users.user_nicename, wp_table_1.name FROM wp_users JOIN wp_table_1 ON wp_users.ID=wp_table_1.name
Link to comment
https://www.neowin.net/forum/topic/1317318-sql-query-need-some-help/Share on other sites
7 answers to this question
Recommended Posts