# MySQL query not returning true value?

**URL:** <https://forum.kirupa.com/t/mysql-query-not-returning-true-value/285019>\
**Category:** programming\
**Created:** [March 26, 2009, 6:53am UTC](https://forum.kirupa.com/t/mysql-query-not-returning-true-value/285019 "2009-03-26T06:53:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![krissauquillo](https://avatars.discourse-cdn.com/v4/letter/k/839c29/32.png) [@krissauquillo](https://forum.kirupa.com/u/krissauquillo)\
**Post date:** [March 26, 2009, 6:53am UTC](https://forum.kirupa.com/t/mysql-query-not-returning-true-value/285019/1 "2009-03-26T06:53:13Z")

</div>

Hi folks, I am using the following MySQL query in my PHP script:

SELECT FROM\_UNIXTIME(com\_date, ‘Week %V; %M %X’) as week FROM comments GROUP BY week ORDER BY com\_date DESC

The server is returning only 110 weeks, but in reality there are 129.

You can see it, here:  
[http://vilegaming.com/statistics.php?m=commentactivity&n=weekly&start=120](http://vilegaming.com/statistics.php?m=commentactivity&n=weekly&start=120)  
…you will notice it says only 110 weeks, but also page 7 of 6 (20 weeks per page).