Determining First and Last Dates of the Week

[mharxx]

Hi All,

I have a problem regarding on how to determine the first and last dates of the week given the week number in mysql. Can anyone help me here please!!

Thanks,
Mharxx

[Weedpacket]

http://www.phpbuilder.com/board/showthread.php?t=10222903&highlight=starting+date

[mharxx]

Thank You very much AMigo for replying && sending a link regarding this. Actually I've created a script coz I really have to, and maybe this could help too.

if(!empty($WeekNumber)){

			if(empty($StartDate) && empty($EndDate)){
					$rsMe = mysql_query("SELECT CURDATE() as today");
					$tOdAY = mysql_result($rsMe,0,"today");
					$rsGetWeek = mysql_query("SELECT MID(YEARWEEK('".$tOdAY."'),5,2) as WeekV");

					if(mysql_result($rsGetWeek,0,"WeekV") < $WeekNumber){
						$strCMPA = "DATE_ADD";
					}else{
						$strCMPA = "DATE_SUB";
					}


					while(1){
						$sQl = "SELECT $strCMPA('$tOdAY',INTERVAL 2 DAY) as evalDay";
						$rSEval = mysql_query($sQl);
						$tOdAY = mysql_result($rSEval,0,"evalDay");
						$rsGetWeek = mysql_query("SELECT MID(YEARWEEK('".$tOdAY."'),5,2) as WeekV");
						if(mysql_result($rsGetWeek,0,"WeekV") == $WeekNumber){
							break;
						}	
					}
					$StartDate = $EndDate = $tOdAY;
			}

			$retDate["Start"] = $StartDate; 
			$retDate["End"]	  = $EndDate;

			for($j=0; $j < sizeof($retDate); $j++){	
				switch($j){
					case 0:
							$strCMP = "DATE_SUB";
							$IDX = "Start";
							break;
					case 1:
							$strCMP = "DATE_ADD";
							$IDX = "End";
							break;				
				}
				while(1){
					$rsDiff = mysql_query("SELECT $strCMP('".$retDate[$IDX]."', INTERVAL 1 DAY) AS SdateA");
					$SqL = "SELECT MID(YEARWEEK('".mysql_result($rsDiff,0,"SdateA")."'),5,2) as WeekA";
					$rsDayWeekA	 = mysql_query($SqL) or die (mysql_error());
					if(mysql_result($rsDayWeekA,0,"WeekA") == $WeekNumber){
						$retDate[$IDX] = mysql_result($rsDiff,0,"SdateA");
					}else{
						break;
					}
				}	
			}	
			return $retDate;