Page 1 of 1

Retrive from mysql by date

Posted: Thu Dec 23, 2010 10:16 am
by lanceydavid
Hello,
this is my first time on this forum and also a modest newb on php, but i heard alot of people i know visit this site to get help on php. So i have a question, i know how to submit a form to mysql, the question is how do i recieve each indivual data i submit with the form by date and display it in order by date. i would like to submit kind of a status up everyday similar to twitter but order it by date and have it look kinda like:

July 5, 2006

This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.

July 4, 2006

This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.

Re: Retrive from mysql by date

Posted: Thu Dec 23, 2010 7:44 pm
by anantha
create an extra field in ur table called say created as timestamp field...and every time you save to db...then date and time get stored...so based on the created field you can order and display the data..