Sql php query script - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

corey · 09-14-2005, 07: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

websitedatabases · 09-15-2005, 06:52 PM

Hello,

When you build your script you query should look something like this:

PHP Code:


		
			
$q = 'select * from mytable where latest_timestamp_date BETWEEN NOW() AND NOW() + INTERVAL 7 DAY order by latest_timestamp_date desc limit 20;';

Hope this helps