2 replies to this topic

[Marxx]

Hi all..

can't figure this out.. How can I archive my written text from sql?

I have in my database text which I need to archive by month and/or year.. Just like all blog systems do.
Well, I guess that this explais it all?


Thanks for all help..

[Matthew.]

It's quite simple assuming you are using date/time in what I would say is the best way

If you are using a DATETIME field you can do a query like this:

SELECT * FROM `table` WHERE DATE_FORMAT(timestamp, '%m') = 6

That will take the DATETIME field (called in this case timestamp) and format it into the month number (much like date() would do with a unix timestamp) so you then check it against the number of the month you want to select articles for. In this case, 6, June.

The theory for day/week/month/year is much the same. %d %U (or %u) %m %y

http://dev.mysql.com/doc/refman/5.0/en/dat...ion_date-format

[Marxx]

Brilliant .. That is quite simple!

I'll try it from here and maybe I need more help, maybe not..

Thank you Matthew.