Yes, the values echo out the way I expect them. But these are displayed values, not dates, I'm pretty sure, and that is why the comparison is failing.
The question began very simply. I will try to make it simpler:
How do I compare a string date from a database to today's date using PHP?
I can do it with my eyes closed in SQL. I don't want to if I can avoid it.
Jason Wong <php-db@xxxxxxxxxxxx> wrote:
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 "
License has expired
";
> }
> Else
> {
> echo "
License has not expired
";
> }
>
> 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
---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
