Member Avatar for pbcomput

hi.

i want to check expire date with mysql query between start date and enddate.

if the end date is bigger then today's date then its good else it didnt display records.


can any one please help me out.


Thanks in advance. :)

  • 5 Contributors
  • 5 Replies
  • 183 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by jhansianamaneni
Member Avatar for pbcomput

if any one know plase help me out.

Thanks.

Member Avatar for zaxonus

How about using this condition ?
(EnDate<now())

This is what use myself and it works fine.

Member Avatar for Taywin

Don't think this question is for javascript??? Or you are talking about attempting to do the comparison of dates obtained by mysql on a HTML page?

Member Avatar for jhansianamaneni

select * from table name where account_expiry < now();
try this it is working fine.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.