从MySQL表中选择PHP时间戳早于X的行 [英] Select rows from MySQL table where PHP timestamp is older than X
本文介绍了从MySQL表中选择PHP时间戳早于X的行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个用户表,需要在此表中批准用户,我想显示未批准并在7天前注册的用户.
I have a user table, where users need to be approved, i want to show users who are not approved and is registered more than 7 days ago.
我的user_regdate是使用php time()函数创建的时间戳.
My user_regdate is a timestamp created with php time() function.
这是我尝试的方法,它不起作用:
This is what i try, it does not works:
mysql_query("select * from users WHERE user_regdate < now() - interval 7 day AND approved='0' order by id;");
谢谢
推荐答案
PHP的timstamp是一个简单的整数,而MySQL的now()
返回日期时间值.这很可能会解决该查询:
PHP's timstamps are a simple integer, whereas MySQL's now()
returns a datetime value. Most likely this will fix up the query:
SELECT ... WHERE user_regdate < unix_timestamp(now() - interval 7 day)) ...
基本上,没有unix_timstamp()调用,您正在比较苹果和橘子.
Basically, without the unix_timstamp() call, you're comparing apples and oranges.
这篇关于从MySQL表中选择PHP时间戳早于X的行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文