TalkPHP - View Single Post

sjaq · 05-03-2009, 08:02 PM

The views row already defaults to 0. The problem is when one of the SELECTS has no results e.g. there are no items in data_id_custom for user_id 12 so SUM(views) can't count any data.

This is the structure for both tables:

05-03-2009, 08:02 PM	#3 (permalink)
sjaq The Acquainted Join Date: Nov 2007 Location: Netherlands Posts: 113 Thanks: 11	The `views` row already defaults to `0`. The problem is when one of the `SELECT`S has no results e.g. there are no items in `data_id_custom` for `user_id 12` so `SUM(views)` can't count any data. This is the structure for both tables: Last edited by sjaq : 05-03-2009 at 08:07 PM. Reason: smaller screenshot