Re: [PHP] Date function and MySQL

2005-07-20 Thread kalinga
this seems pretty interesting, i'm tring to write a code in php to get those two outputs, but bit confused in counting weeks. could somebody clear me.. what is the first *date* of the first week of year 2005? is it saturday jan 1st 2005 (assuming first week starts from jan 1 of any year) or is

Re: [PHP] Date function and MySQL

2005-07-20 Thread kalinga
Hi all. I have the week number (for example, this is the 29th week of the year and it begins on 7/17/05). Does anyone know how to obtain the first (and maybe the last) date of the week if you only know the week number of the year? Would it be better for me to obtain this in PHP

Re: [PHP] Date function and MySQL

2005-07-19 Thread Arno Coetzee
Philip Thompson wrote: Hi all. I have the week number (for example, this is the 29th week of the year and it begins on 7/17/05). Does anyone know how to obtain the first (and maybe the last) date of the week if you only know the week number of the year? Would it be better for me to

[PHP] Date function and MySQL

2005-07-18 Thread Philip Thompson
Hi all. I have the week number (for example, this is the 29th week of the year and it begins on 7/17/05). Does anyone know how to obtain the first (and maybe the last) date of the week if you only know the week number of the year? Would it be better for me to obtain this in PHP or MySQL?