[SOLVED] PHP NOW() Issue

[dlebowski]

Hello.  I am running this query below to show only events happening today and forward:

 

SELECT date_FORMAT(AuctionDate, '%M %e, %Y') as newdate, AuctionDescription, AuctionTitle, AuctionDate, AuctionTime, AuctionAddress, AuctionCity, AuctionState, AuctionCity, AuctionZip FROM auctions WHERE AuctionDate >= NOW() ORDER BY AuctionDate

 

For some reason, it only shows values for events GREATER than today.  So today's events are not showing up.  It used to work and now it doesn't.  I recently changed from PHP 4 to PHP 5.  Is there something I need to change with ">= NOW()"?  That is the only think I can think of.  Any suggestions?  I did confirm that the time on my server is correct.  Thanks!

[Daniel0]

This is strictly SQL, so the problem has nothing to do with the upgrade? Do you get any errors?

[SammyGunnz]

Just curious...what format are you storing your AuctionDate in?

[dlebowski]

Here is what I ended up doing to get this to work.  (By the way, I recently upgraded my version of mysql as well)  So there must be something that doesn't jive in the new version of mysql in regards to NOW().

 

Here is what I did to get around it:

$date = date("Y-m-d");
SELECT date_FORMAT(AuctionDate, '%M %e, %Y') as newdate, AuctionDescription, AuctionTitle, AuctionDate, AuctionTime, AuctionAddress, AuctionCity, AuctionState, AuctionCity, AuctionZip FROM auctions WHERE AuctionDate >= '$date' ORDER BY AuctionDate