Left Outer Join

[RON_ron]

I'll getting data from two different databses. Code A is the current code (works well). After doing some modifications (Code B), now the code outputs nothing . Could someone help to correct the error in Code B?

 

Code A

 

$query = "SELECT * FROM furniture LEFT OUTER JOIN furnitureBrands ON furniture.itemCode = furnitureBrands.theName ORDER BY furniture.key DESC;
$results = mysql_query($query);

 

Code B

$query = "SELECT * FROM furniture LEFT OUTER JOIN furnitureBrands ON furniture.itemCode = furnitureBrands.theName WHERE furniture.checked = '0', furniture.availability = 'yes' ORDER BY furniture.key DESC;
$results = mysql_query($query);

 

Thanks.

[Barand]

A look at the value of mysql_error() helps in these circumstance.

 

Do that,then try

 

$query = "SELECT * FROM furniture
 LEFT OUTER JOIN furnitureBrands ON furniture.itemCode = furnitureBrands.theName
WHERE furniture.checked = '0'
 AND furniture.availability = 'yes'
ORDER BY furniture.key DESC";

Edited November 23, 2012 by Barand