display posts between 2 dates

techmeister

Hi there:

I'm building a bulletin board system. I'd really like to know how, using MySQL functions (or php4) I can have a user specify that his post appear between two dates of his choosing, and delete itself on the second of the two dates.

I've been using php/MySQL for ages but I suck at dates! Can anyone help me out?

Many thanks!
Russ

saltwater

use the unix timestamp: mktime(); and save it in your database for every message, then if you want to select the messages you give mktime the date parameters for the startdate and enddate (so you have both timestamps) and then you query your database as follows: "SELECT <fields> FROM <table> WHERE time>'$startdate' AND time<'$enddate'"

techmeister

I can't quite get my head round what you mean! (Sorry - i really do hate dates)

You said:

use the unix timestamp: mktime(); and save >it in your database for every message.
So use a Timestamp for the exact date and time of each post, and call this field 'time' (For this example) - right?

You also put the query as:
"SELECT <fields> FROM <table> WHERE time>'$startdate' AND time<'$enddate'"

But 'time' will never be greater than $startdate because it will have to have been before the startdate. (As the startdate is always in the future.)

If this isn't what you meant please please explain in a bit more detail!

Many thanks!
Russ

techmeister

OOps!!! I think I know what you mean now!
I'll give it a shot!!

Thank you very much!
Russ :-)

techmeister

Just to let all those know who are reading this and searching thru the archives:

I got my posts to display between the specified dates by using:

"SELECT * FROM <table> WHERE now()>=dateFrom AND now()<=dateTo";

Hope this helps someone else!
Cheers for pointing me in the right direction Bruno!

Russ

saltwater

no problem dude :o)