Please see the following image for context: <http://clip2net.com/s/2hHUe>

I am selecting LatestMood for example from this table but as you can see the mysql is only showing 9 of the 10 found because the latest row's LatestMood is blank - how can I avoid this - or rather how can i show all of the rows regardless of if a value is blank or not. 

The problem is that `mysql_num_rows` shows 10 and `mysql_fetch_array` holds 9