• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql query to check the date

 
preethi Ayyappan
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am doing a program like phone booking.Now what i need is, a person who had booked a product already in last 15 days should not book another time within that 15 days.what is the mysql query to check whether he had booked already within last 15 days.

Thanks.
 
preethi Ayyappan
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thank you for your reply.
i want to check whether the systemdate and registered date is greater than 20.if yes i want to update the flag and registered date.if not ,it should go to else part.But my code does not goes to the else part even the condition is false.where am i wrong?my code follows:

please help me to find my error.

Thanks.
 
preethi Ayyappan
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got the result. Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic