MySQL/PHP Date

[Jack Franklin]

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]

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]

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