本文介绍了PHP和MYSQL的日期到期日的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想做的是当用户登录时,我想通知他们产品将会过期
What I wish to do is when the user logs in I want to notify them that the product is going to expire
任何想要使用什么查询的想法为了这个,我可以这样做吗?
Any ideas of what queries I need to use for this and how I can do this please?
谢谢。
推荐答案p> 检查此
SELECT p.ProductName, s.Quantity, s.Price, s.DateExpiry FROM seller s, Product p WHERE p.PID = s.PID AND Custid = $_SESSION['user'] AND (DateExpiry BETWEEN curdate() and curdate() + interval 3 day) ORDER BY DateExpiry更多推荐
PHP和MYSQL的日期到期日
发布评论