Hey, I've run into a bit of a problem;
I've written a guestbook that, among other things, stores the date that the post was submitted and the persons IP Address. What i'm looking for is a way to stop someone posting twice in the same day.
Now, this sounds easy enough, but the trouble i have is that the way i'm storing the date in the database is as a blob and writing it in the format date("l, j M Y, H:i").
So far, what i've done is to check whether the persons IP Address exists in the table. If it doesnt then write the post successfully. If the IP Address does exist however, then check the date and see if the date matches. But i'm having difficulty checking if the dates are the same or not.
How do i check:
Friday, 13 May 2005, 14:23 and Friday, 13 May 2005, 16:00. They're the same dates but how would i extract just the part that reads '13 May 2005'??
Any help would be appreciated as i am getting a lot of hassle from annoying visitors. Thanks. If you need me to post any of my code, i would be more than happy.
BIOSTALL
