All pastes #639436 Raw Edit

Unnamed

public php v1 · immutable
#639436 ·published 2007-07-30 15:56 UTC
rendered paste body
	// if weeks	$wyear = substr($date_from_week, 0, 4);	$wdays = (substr($date_from_week, 4, 2) * 7)-7;	$wqx = "SELECT UNIX_TIMESTAMP(DATE_ADD( DATE_SUB('".$wyear."-01-01 00:00:00', INTERVAL( WEEKDAY( '".$wyear."-01-01 00:00:00' ))DAY), INTERVAL( ".$wdays." )DAY)) AS START, 			UNIX_TIMESTAMP(DATE_ADD( DATE_ADD('".$wyear."-01-01 23:59:59', INTERVAL( 6 - WEEKDAY('".$wyear."-01-01 23:59:59'))DAY), INTERVAL( ".$wdays." )DAY)) AS END";	$wresultx = mysql_query($wqx);	$wrowx = mysql_fetch_row($wresultx);	$week_from = $wrowx[0];	$week_to = $wrowx[1];		echo 'week_from: '.date('d/m/y h:i:s',$week_from);	echo 'week_to: '.date('d/m/y h:i:s',$week_to);