One thing caught my eye. You pass $query to mysql_fetch_assoc(). It's impossible to know without seeing all of the code, but most code examples use the variable $result for the results of the call to mysql_query() which is then passed to mysql_fetch_assoc(). Could you have mixed these up?
Ok, i managed to get around this problem using a for loop dependent on the $count number (since that part was working), and putting $row = mysqli_fetch_row at the beginning of the loop.
Now I have another stop in my path (let me know if it would be better to create a new topic for this one)
I have everything in working order, now the thing is I would like to reverse the order of the rows fetched, starting with the last and ending with the first.
So instead of getting Jan 23, Jan 24, Jan 25, etc., it would be reversed to show the latest date first. I have tried to make this work, but seem to be getting no change, this is now my code, I have added a mysqli_data_seek($query, $rcount) to the beginning of the reversed loop hoping to reverse the row order, but it doesn't seem to change it.
I tried that as well, but the order is actually being done by the for loop. If it was a while($row = mysqli_fetch_assoc($query)) function, then yeah an ORDER BY would have worked...wait a sec, I think I found my problem...yup I got it now, I was reversing the wrong loop.
there, this matter is solved! Thanks everyone for your input