MySQL/PHP Date

Jack Franklin · #1 Jan 31st, 2008, 16:32

Hey all. I have a post stored in a table, with a field called date. On the website, I want to display the following using PHP/MySQL: This puzzle ends on: (date of puzzle + 1 week).

So, it takes the date the puzzle was added to the table, and adds 1 week to it, and displays that date.
My current code is:

PHP: Select all


$get_latpuz = mysql_query("SELECT contentid, contenttitle, category, homepage, date_format(date, '%b %D, %Y') AS date FROM content WHERE category='Puzzles' ORDER BY contentid DESC LIMIT 0 ,1");
while ($lat_puz = mysql_fetch_array($get_latpuz)) {
$postid = $lat_puz['contentid'];
$posttitle = $lat_puz['contenttitle'];
$postdate = $lat_puz['date'];
echo '<li><a href="single.php?contentid=' . $postid . '">' . $posttitle . '</a></li>';
}

Then I want to add:

PHP: Select all


echo 'Puzzle ends on: (Date + 1 Week)';

Hope I made sense.

Jack

kidreapertronV · #2 Jan 31st, 2008, 17:00

I wish I could give you specifics about how to insert this into your particular code, but I'm pretty sure you can specify the puzzle ends on date by using this code...

PHP: Select all


DATE_ADD(CURDATE(),INTERVAL 1 WEEK)

Check out the MySQL info on DATE_ADD() for more info.

Good luck!

Jack Franklin · #3 Jan 31st, 2008, 17:44

No luck I'm afraid. Cannot figure out how to intergrate it in. Any ideas?
Appreciate the help so far

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to compaire Stored Dates with System Date (PHP-MYSQL)	jeffry	PHP Forum	3	Feb 22nd, 2007 02:15
Convert date to MySQl format	AdRock	PHP Forum	4	Jan 15th, 2007 09:41
Changing date format in date picker	AdRock	JavaScript Forum	1	Aug 1st, 2006 17:16
Date in Asp	Gup	Classic ASP	1	Jun 5th, 2006 09:05
asp date	Monie	Classic ASP	1	Sep 21st, 2004 04:38

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
MySQL/PHP Date