LEFT JOIN Doesn't work correctly

[lasha]

Hello all

 

This code below works but doesn't filter records by owner.

 

Please help. thanks

SELECT * FROM books
LEFT JOIN car ON books.car_id = car.id
LEFT JOIN cat ON books.cat_id = cat.id
WHERE
books.owner = '$owner'

[Barand]

Have you tried echoing the query string to check it is submitting what you think it's submitting?

Have you checked $owner has a value?

Have you checked if mysqli_error() returns a message?

[lasha]

Thanks for answer

 

There is 2 owners, and when owner1 is logged in it does filter and shows only owner1 records. But when owner2 - it shows all result for owner1 and owner2

 

Yes i tried everything what you suggest and all is ok

Edited March 23, 2014 by lasha

[Barand]

http://uk3.php.net/manual/en/mysqli.error.php

[lasha]

Ok i dont know what was problem, but i deleted records in db and insert it again and now works fine. i think db records were broken or something.

Anyway, thank you very much Barand