[eluser]seanloving[/eluser]
[quote author="noctrum" date="1264212125"]Can you post the actual SQL being run by enabling profiler?
Also, you can use IFNULL to display 0 instead of NULL
Code:
SELECT IFNULL(qty, 0) AS qty
[/quote]
@noctrum-
I like IFNULL, but not sure if I'm using it properly.
Take a look at my SQL and output [EDIT --> remove link]
there are many products in my products table...
but my inventory table has only 3 entries...
-(inventory_id=1) product_id=1
-(inventory_id=2) product_id=2
-(inventory_id=3) product_id=2
I want to see all the products in my products table on display here, with QTY column showing 0 for those products that don't show up on the inventory table.
-SL