[SOLVED] Grabbing data from another table using INNER Join.

[Brad]

So I'm trying to grab items from a table WHERE the items ID = 202, but where the user_ids RANK is < 4 . but the Items table doesn't define the rank so you'd have to grab that from the other table (users). I'm using INNER JOIN which I've never done before and it's confusing the hell out of me.

Here's my current code.

                        $result = mysql_query("SELECT i.base_item, i.user_id FROM items WHERE i.base_item ='202' AS i
                        INNER JOIN users AS u
                        ON i.user_id= u.id WHERE u.rank < 4");
                      
                         $num_rows = mysql_num_rows($result);

This isn't grabbing anything so I don't know what needs fixing. Thanks

 

[RastaLulz]

At first glance, you should be setting items to i on the FROM clause, and not the WHERE clause.

 

[Brad]

At first glance, you should be setting items to i on the FROM clause, and not the WHERE clause.

It works when I remove the WHERE clause, but I need it to display a certain item.

 

[Ecko]

ON i.user_id= u.id WHERE u.rank < 4

that won't work

 

[Brad]

ON i.user_id= u.id WHERE u.rank < 4

that won't work

hmm, any other way?

 

[Jaden]

Try this (not confirmed)

SELECT I.base_item, I.user_id
FROM items I INNER JOIN users U
ON I.user_id = U.id
WHERE U.rank < 4

 

[Brad]

Fixed it thanks, turns out I have to use there WHERE clause at the end. Thank you for those who helped.

 

[Jaden]

Fixed it thanks, turns out I have to use there WHERE clause at the end. Thank you for those who helped.

I knew it was "WHERE" instead of "AND", I was going to ask you to try that next.