[RESOLVED] NOW() in an if statement?

[Chris_96_WS6]

I am working on a calendar that displays dates for training classes my department offers.

The staffperson who enters new classes puts in a date she wants registration to open.

I want the page to display all the classes and then, depending on this registration date, either display a link to the registration form, or display "registration begins on X date"

My problem is that I cannot construct the IF statement correctly. Here is the code:

if ($row2->RegDate > NOW()) {

   echo "<a href=\"http://www.mysite.com/register.php?selected=$SessionID\">Register Online</a>";

    } else {

    echo "Registration begins 1/1/07";

    }

and it displays this error in the browser:

Fatal error: Call to undefined function: now() in /home/htdocs/oor/gcm/calendar/betacalindex.php on line 422

I am at a loss, because NOW() seems to work in queries when I want to pull only classes with an event date later than today.

[bpat1434]

NOW() is a mySQL function. You may want to use [man]time/man instead.

[Chris_96_WS6]

Ah, I see. Its working now, thanks!

Well, that is to say the error is gone. the If statement doesn't seem to be working however.

I'm using a datetime field in the database and simply calling that up for the if statement. Do I need to condition the value in RegDate first before putting it into the If statement?

[bpat1434]

How are you storing it in the database? What format? Which is it most like?

2006-11-02 17:53:00
20061102175300
10348750108301 <-- Seconds since Unix Epoch

If it's seconds since Unix Epoch, then you should be able to say if(time() > $dbTime) {}; otherwise, you'd wnat to say if(time() > strtotime($dbTime)) {}....

[Chris_96_WS6]

I figured it out. Its stored YYYY-MM-DD 00:00:00 I found a page on php.net that explained how to format Date()

I did $today = date("Y-n-h G:i:s");

Which works functionally, but $today ends up being 11/05/2006 instead of today (11/2/06)....so I'm not sure where the extra three days are coming from but it is throwing off the output.

Thank you.

[Installer]

I don't see how you're getting "11/05/2006" with that, especially since "n" give the month without leading zeros, and "h" give the hour, not the day, and you're using hyphens, not slashes, and you have the year first, etc. So you should be seeing something like "2006-11-05 17:46:26". Try "Y-m-d H:i:s".

[bpat1434]

I think your $today value should be: date('Y-m-d H:i:s'); that may work out better for you...

[Chris_96_WS6]

Perfect. Thanks. This is my first real foray into Dates and frankly it is pretty confusing.