Retrive from mysql by date

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
lanceydavid
Forum Newbie
Posts: 1
Joined: Thu Dec 23, 2010 10:09 am

Retrive from mysql by date

Post 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.
anantha
Forum Commoner
Posts: 59
Joined: Thu Dec 23, 2010 7:38 pm

Re: Retrive from mysql by date

Post 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..
Post Reply