RE: [PHP] date() and mktime() functions: weeknumbers and months.
Thanks Jason and Marek, I was thinking to difficult, Thanks for the quick responses. Best regards, Davy Obdam > -Oorspronkelijk bericht- > Van: Jason Wong [mailto:[EMAIL PROTECTED] > Verzonden: maandag 31 maart 2003 16:36 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: [PHP] date() and mktime() functions: > weeknumbers and months. > > > On Monday 31 March 2003 22:07, Davy Obdam wrote: > > > I would like to select news from my database bases on week/year and > > month/year. How can i do this.. I would like to pass two > arguments in > > the query string, like news.php?week=14&year=2003 or > > news.php?month=3&year=2003. Can anybody help me.. Thanks in > advance. I > > have been looking at the > > date() and mktime() functions, but is there anyway to determine the > > date from a weeknumber? I have been using this: > > [snip] > > > $sql = "SELECT * FROM news WHERE date>='$last_sunday' AND > > date<='$next_saturday'). > > > > But i would find it better to use a weeknumber instead > > If you're using mysql you can do something like: > > SELECT * FROM news WHERE WEEK(date) = some_week_number_or_another > > If you're using some other DBMS check whether it has some > similar function. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications > Development * > -- > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-general > > -- > /* > We can predict everything, except the future. > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > Deze e-mail is door E-mail VirusScanner van Planet Internet > gecontroleerd op virussen. Op http://www.planet.nl/evs staat > een verwijzing naar de actuele lijst waar op wordt gecontroleerd. > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] date() and mktime() functions: weeknumbers and months.
On Monday 31 March 2003 22:07, Davy Obdam wrote: > I would like to select news from my database bases on week/year and > month/year. > How can i do this.. I would like to pass two arguments in the query > string, like news.php?week=14&year=2003 or news.php?month=3&year=2003. > Can anybody help me.. Thanks in advance. I have been looking at the > date() and mktime() functions, but is there anyway to determine the date > from a weeknumber? I have been using this: [snip] > $sql = "SELECT * FROM news WHERE date>='$last_sunday' AND > date<='$next_saturday'). > > But i would find it better to use a weeknumber instead If you're using mysql you can do something like: SELECT * FROM news WHERE WEEK(date) = some_week_number_or_another If you're using some other DBMS check whether it has some similar function. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* We can predict everything, except the future. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] date() and mktime() functions: weeknumbers and months.
Check out mysql manual, section 6.3.4 - Date and Time Functions, example
$condition='';
if($GET['week']) $condition .= "WEEK(date)='$_GET[week]' AND ";
if($GET['year']) $condition .= "YEAR(date)='$_GET[week]' AND ";
and so on
then use the condition:
$sql = "SELECT * FROM news WHERE $condition 1";
Davy Obdam wrote:
Hi people,
I would like to select news from my database bases on week/year and
month/year.
How can i do this.. I would like to pass two arguments in the query
string, like news.php?week=14&year=2003 or news.php?month=3&year=2003.
Can anybody help me.. Thanks in advance. I have been looking at the
date() and mktime() functions, but is there anyway to determine the date
from a weeknumber? I have been using this:
$yr="2003";
$mnth="03";
$dy="31";
echo "base date: ".$yr."-".$mnth."-".$dy."";
echo "last sunday: ".date("Y-m-d",
mktime(0,0,0,$mnth,$dy-date("w",mktime(0,0,0,$mnth,$dy,$yr)),$yr))."
/>";
echo "next saturday: ".date("Y-m-d",
mktime(0,0,0,$mnth,$dy+6-date("w",mktime(0,0,0,$mnth,$dy,$yr)),$yr))."
r />";
$sql = "SELECT * FROM news WHERE date>='$last_sunday' AND
date<='$next_saturday').
But i would find it better to use a weeknumber instead
Best regards,
Davy Obdam - Networking4all
Webapplication developer
E-mail: [EMAIL PROTECTED]
Web: http://www.networking4all.com
Kijk ook eens op: http://www.verzamelgids.nl
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] date() and mktime() functions: weeknumbers and months.
Hi people,
I would like to select news from my database bases on week/year and
month/year.
How can i do this.. I would like to pass two arguments in the query
string, like news.php?week=14&year=2003 or news.php?month=3&year=2003.
Can anybody help me.. Thanks in advance. I have been looking at the
date() and mktime() functions, but is there anyway to determine the date
from a weeknumber? I have been using this:
$yr="2003";
$mnth="03";
$dy="31";
echo "base date: ".$yr."-".$mnth."-".$dy."";
echo "last sunday: ".date("Y-m-d",
mktime(0,0,0,$mnth,$dy-date("w",mktime(0,0,0,$mnth,$dy,$yr)),$yr))."";
echo "next saturday: ".date("Y-m-d",
mktime(0,0,0,$mnth,$dy+6-date("w",mktime(0,0,0,$mnth,$dy,$yr)),$yr))."";
$sql = "SELECT * FROM news WHERE date>='$last_sunday' AND
date<='$next_saturday').
But i would find it better to use a weeknumber instead
Best regards,
Davy Obdam - Networking4all
Webapplication developer
E-mail: [EMAIL PROTECTED]
Web: http://www.networking4all.com
Kijk ook eens op: http://www.verzamelgids.nl
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
