On Saturday 08 November 2003 02:44, Karen Resplendo wrote:
> Apache on NT using MS SQL Srvr 2000
> PHP 4.03pl1
>
> I return these dates into strings and now I want to compare my database
> date to see if it is later than today's date. Pretty sure my "Expires"
> field is a string:
>
> Here is the "Expires" field from the SQL:
> Convert(varchar, DATEADD(Year,3,DateCertified),101) AS Expires
>
> Here is my PHP code trying to compare dates:
>
> $today = date("m/d/Y");
>
> If ($today < odbc_result($data,"Expires"))
> {
> echo "<br><br>License has expired<br><br>";
> }
> Else
> {
> echo "<br><br>License has not expired<br><br>";
> }
>
> Sure could use a simple solution to a simple problem that has me simply
> confounded.
Why not just do the comparison directly within the query?
And if you want to get the above working, have you tried debugging it?
Like:
print($today);
print(odbc_result($data,"Expires"));
Are they what you expected them to be?
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Alaska:
A prelude to "No."
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
