SQL left join part of the array is empty

Question

My problem is the following code the comment&rating area of the array should have a comment in it as the DB history table does ...?

 SELECT users.uid, users.username, history.user_id, history.comment, history.rating
 FROM history
 LEFT JOIN users
 ON users.uid=history.user_id
 WHERE history.book_id="$bid"

It returns :

 Array ( [uid] => 3 [username] => Reign [user_id] => 3 [comment] => [rating] => )

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented Mar 8, 2013 at 20:59
it is obviously returning a history record, since history.user_id is 3 in the result. are you sure there's a comment and rating set on that particular record? — Marc B
– Marc B, Commented Mar 8, 2013 at 21:02
Shouldn't do ="$bid" either. That's a SQL injection mistake. Should change to =:bid. — Luke
– Luke, Commented Mar 8, 2013 at 21:07

Kermit · Accepted Answer · 2013-03-08 21:00:55Z

4

Then you want to use an INNER JOIN. A LEFT JOIN will return NULL values.

SELECT users.uid, users.username, history.user_id, history.comment, history.rating
FROM history
INNER JOIN users
ON users.uid=history.user_id
WHERE history.book_id="$bid"

answered Mar 8, 2013 at 21:00

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL left join part of the array is empty

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related