MySQL calling in Username to show instead of ID!

Posted by Jess on Stack Overflow See other posts from Stack Overflow or by Jess
Published on 2010-03-17T02:11:28Z Indexed on 2010/03/17 2:21 UTC
Read the original article Hit count: 287

Filed under:
|
|
|

I have a users table, books table and authors table. An author can have many books, while a user can also have many books. (This is how my DB is currently setup). As I'm pretty new to So far my setup is like bookview.php?book_id=23 from accessing authors page, then seeing all books for the author. The single book's details are all displayed on this new page...I can get the output to display the user ID associated with the book, but not the user name, and this also applies for the author's name, I can the author ID to display, but not the name, so somewhere in the query below I am not calling in the correct values:

SELECT users.user_id, 
       authors.author_id, 
       books.book_id, 
       books.bookname, 
       books.bookprice, 
       books.bookplot 
  FROM books 
INNER JOIN authors on books.book_id = authors.book_id 
INNER JOIN users ON books.book_id = users.user_id 
 WHERE books.book_id=" . $book_id;

Could someone help me correct this so I can display the author name and user name both associated with the book! Thanks for the help :)

© Stack Overflow or respective owner

Related posts about mysql

Related posts about inner