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")
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 <= $to
from today:
SELECT * FROM mytable WHERE mydate < DATE_ADD(now(), INTERVAL 14 DAY);
-Original Message-
From: Ben S. [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date Calculation
How do you get the date that is 14 days from
4, this year, then return it formatted as yyy-mm-dd
HTH
Beau
// -Original Message-
// From: Ben S. [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 13 November 2001 1:49 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Date Calculation
//
//
// How do you get the date that is 14 days f
How do you get the date that is 14 days from today's date?
I can get that date with mysql monitor but PHP. I am using PHP4 and MySQL. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
How do you get the date that is 14 days from today's date.
I am using PHP4 and MySQL. I can get that date with MySQL monitor but php. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail