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

websitedatabases · 09-15-2005, 07: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

09-15-2005, 07:52 PM	#2 (permalink)
websitedatabases Junior Member Join Date: Jul 2005 Posts: 12	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 __________________ Build your own PHP MySQL web databases