if time = this month?

[Incredinot]

Hi..

 

So im working on a code where i need to show only content that was created withing the given month...

 

Example: If we are in febuary - only show febuary content..

 

How can such a thing be written?

 

<?php $time = time();

if($time == ?){print "Content"; }?>

 

Do you write it like "If its bigger than this and lesser than that?"

[Adam]

How are you storing the content; a database?

[ignace]

select * from articles where month(now()) = month(article_date)

[Incredinot]

Date's are timestamps, and my db is stored like:

 

id 	description 	 date 	 	 user
---------------------------------------------------
1 	something.. 	 1268837274    username
2 	blablabla.. 	 1269194039    username2

[gamblor01]

There is a function called from_unixtime() in MySQL.  You can use this to convert a Unix timestamp to the 'date' datatype.  Then just wrap that with a call to the month() function:

 

 

mysql> select from_unixtime(1268837244) as date;
+---------------------+
| date                |
+---------------------+
| 2010-03-17 09:47:24 | 
+---------------------+
1 row in set (0.00 sec)

mysql> select month(from_unixtime(1268837244)) as month;
+-------+
| month |
+-------+
|     3 | 
+-------+
1 row in set (0.00 sec)

 

 

Ignace's answer is almost exactly what you need.  Just modify it to use the from_unixtime() function and it should work.  Try something like this:

 

select * from articles where month(now()) = month(from_unixtime(date));