Jump to content


Photo

select statement : today


  • Please log in to reply
2 replies to this topic

#1 LiamG

LiamG
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts
  • LocationMelbourne, Australia

Posted 18 March 2003 - 06:55 AM

Hi guys...hope all are well.

How does one say, like:

SELECT * FROM `calendar` WHERE date = ---TODAY--- ORDER BY `date` DESC LIMIT 0,1

??

Thanks,

LiamG.

ps - also - like --TODAY-- + 1 day

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 18 March 2003 - 07:26 AM

get the date via php\'s date() function and embed it into the query. :D
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 LiamG

LiamG
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts
  • LocationMelbourne, Australia

Posted 18 March 2003 - 09:31 AM

Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users