Hi,
I am currently working on a project where instead of normal dates, they work with week schedules.

So i need to extract the week of any given date from mysql timestamp.

I know it can be done with mktime(0,0,0,Y,M,D), but how to insert the data with PHP ?

Example:

The timestamp MYSQL is: 2010-08-27

Question: how can I use PHP to extract the week of any given date in mysql timestamp form ????

Found some examples but they did not work, or I am overlooking something very very simple here. Can someone help me out ??

Thanks

[SOLVED]

$given_date = 2010-08-27 \\ UNIX timestamp

list($yr,$mn,$dt) = split('-',$given_date); // split the given date in year,month and day

$week=date("W",mktime(0,0,0,$mn,$dt,$yr)); // insert the variables

voila, the week of any given day

Note that timestamp usually refers to the Unix time stamp, or the number of seconds since the epoch (1970-01-01 00:00).

Your method is not wrong, but perhaps a slightly easier way is this:
Retrieve the MySQL time as a real timestamp: SELECT UNIX_TIMESTAMP(yourdate).

yourdate is the mysql date value or datetime value from your table. This returns a large integer, let it be $ts. This large integer can be passed to strftime:

jlinkels

Thanks for your reply.

One thing is odd. I tried strfftime() but got the wrong week number all along. But after checking some of my test functions, i found that I did not use the SELECT UNIX_TIMESTAMP method.

As I already said, I simply overlooked this one.

Many thanks, your post did made my life easier