In the model I talk about a MYSQL view which joins the actual model to each date of the year is the table. If there is no record which matches a date, a nearly empty row is returned by that view, only the ‘date’ column is not null.
When I directly SELECT that view via phpmyadmin, these nearly empty rows are there, but when I iterate the data model in php using foreach, these nearly empty rows are not iterated, they just miss.
I guess its because the ‘id’ column in these rows is null.
Yet I would like to iterate these rows. An easy trick to do that?