Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

corey · 09-14-2005, 08:05 PM

Hello,

I have a MySQL database that I am entering data into with a timestamp field. I would like to create a php script that I can run to show me the last entries in the past 7 days. I think the query will go something like this:

select * from mytable where latest_timestamp_date between.........

Where do I go from here and how can I display the results in a table format in sorted order?

Thanks

09-14-2005, 08:05 PM	#1 (permalink)
corey Junior Member Join Date: Jun 2005 Posts: 28	Sql php query script Hello, I have a MySQL database that I am entering data into with a timestamp field. I would like to create a php script that I can run to show me the last entries in the past 7 days. I think the query will go something like this: select * from mytable where latest_timestamp_date between......... Where do I go from here and how can I display the results in a table format in sorted order? Thanks