[RESOLVED] Date comparison code, is mine wrong

[Dawg]

                        $today = "2008-08-27";
                        $start_date = "2008-08-30";



		//Start date Check

		if (strlen($start_date) > 0)
			{
				$comp_today = strtotime($today);
				$comp_start = strtotime($start_date);
		                print "$comp_today <br> $comp_start <br>";

				if ($comp_start > $comp_today)
					{
						$display = "<p align = \"Center\"><font size=\"3\" face=\"Arial, Helvetica, sans-serif\"><font color=\"#003399\"> <ul> <li>You cannot search for articles beyond Today.</li><br /> </ul> </font></p>";
					}
				else
					{
						$sql .= " WHERE(`date` = '$start_date')";
					}
			}

I put in the dates that I am getting at the time I am testing this.

The question is why does the test not = true and give the specified error message?

Once again I must be blind.

[dagon]

what error message? what test? are you sure you posted the right bit of code?

[Dawg]

If you look at the code you will see a date comparison test.

If the start date is greater than today then an error message is rendered.

I cannot see why the date comparison test never returns a positive test even when I purposely choos a start date far greater than today.

[dagon]

$display is set based on the above, as it should be.

change the start date

$start_date = "2008-08-20";

and $sql is populated, as i would expect it to be,

so what's the problem?

[Dawg]

The comparison test never test as true and the code to set $dislplay is bypassed. The else code is excuted and $sql is concatenated with a date that is greater than $today

[dagon]

one more time.

                        $today = "2008-08-27";
                        $start_date = "2008-08-30";



        //Start date Check

        if (strlen($start_date) > 0)
            {
                $comp_today = strtotime($today);
                $comp_start = strtotime($start_date);
                        print "$comp_today <br> $comp_start <br>";

                if ($comp_start > $comp_today)
                    {
                        $display = "<p align = \"Center\"><font size=\"3\" face=\"Arial, Helvetica, sans-serif\"><font color=\"#003399\"> <ul> <li>You cannot search for articles beyond Today.</li><br /> </ul> </font></p>";
                    }
                else
                    {
                        $sql .= " WHERE(`date` = '$start_date')";
                    }
            } 

result $dispaly is populated with the string above.

                        $today = "2008-08-27";
                        $start_date = "2008-08-20";



        //Start date Check

        if (strlen($start_date) > 0)
            {
                $comp_today = strtotime($today);
                $comp_start = strtotime($start_date);
                        print "$comp_today <br> $comp_start <br>";

                if ($comp_start > $comp_today)
                    {
                        $display = "<p align = \"Center\"><font size=\"3\" face=\"Arial, Helvetica, sans-serif\"><font color=\"#003399\"> <ul> <li>You cannot search for articles beyond Today.</li><br /> </ul> </font></p>";
                    }
                else
                    {
                        $sql .= " WHERE(`date` = '$start_date')";
                    }
            } 

$sql has the sting above added to it.

theres results are exactly what i would expect, so what's the problem?

[Dawg]

nothing

[dagon]

Dawg;10926259 wrote:

nothing

well thanks for that exercise in futility.

[Dawg]

Sorry to have bothered you.

For some reason it was not working before and now it is. I don't know what I did, so I need to look over it and back track.