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
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
Share on other sites
7 answers to this question
Recommended Posts