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);