Re: Date calculation from MySql table

Something like this should work. $today = mktime(0, 0, 0, date("m"), date("d"), date("Y")); $tomorrow = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y")); $sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$today} AND {$tomorrow}"; $thismonth = mktime(0, 0, 0, date("m"), 1, date("Y")); $nextmonth = mktime(0, 0, 0, date("m") + 1, 1, date("Y")); $sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$thismonth} AND {$nextmonth}"; $thisyear = mktime(0, 0, 0, 1, 1, date("Y")); $nextyear = mktime(0, 0, 0, 1, 1, date("Y") + 1); $sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$thisyear} AND {$nextyear}"; HOWEVER, consider to use the mysql date functions instead of a unix timestamp. A. Joseph wrote:

I want to calculate the registed users today Also total users this week Total users this month Total users this year The Mysql table has a row of INT(11) with time() value inserted. I did something like this $today = strtotime("+1 day") Then $sql = "SELECT COUNT(*) FROM table WHERE dateReg <= $today"; Same with year/months also, only I use strtotime("+1 week) for a week, strtotime("+1 month) for a month, Can someone help me with this calculation? On 4/7/08, Bruno Lustosa <bruno.lists@gmail.com> wrote:

On Mon, Apr 7, 2008 at 2:42 PM, Dee Ayy <dee.ayy@gmail.com> wrote:

    
 I was thinking of using output buffering and then making 1 call to

utf8_encode, but I think a better question is, how do I stop using utf8_encode completely?

If all components are using utf-8, you should have no problems with charsets at all. By all components, I mean: - Script files in utf-8; - Database in utf-8; - Database connection using utf-8; - Content-type header set to utf-8. With all these, you're free of charset hell, and can enjoy the beauty of utf-8 completely without problems.

    
 The rendered view I see in Firefox 2.0.0.12 is a question mark "?"

where the French character should have appeared. If I use utf8_encode, the character appears as it should.

Question mark means the character is not utf-8. Check where it comes from. Might be the database or the way you are connecting to it. I don't know much about mysql, I use postgresql. With it, you just have to call pg_set_client_encoding() to make the connection in utf-8 mode, and "create database with encoding='unicode'" to set up a database using utf-8.

    
 Luckily I'm on PHP 4.3.10, so I can't see what mb_check_encoding would

report -- if that would even help normally.

      Shouls upgrade to PHP 5. PHP 4 is way out of date, is not getting

updates anymore, and will not even get security bugfixes after august 8th. It's been almost 4 years since PHP 5 was released. http://www.php.net/archive/2007.php Check the PHP 4 end of life announcement. -- Bruno Lustosa <bruno@lustosa.net> ZCE - Zend Certified Engineer - PHP! http://www.lustosa.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php