[RESOLVED] showing pics from database depending on date

pastra

First and foremost: I´m a beginner in PHP and Mysql.
I´d like change this to retrieve a picture from a database due to date. I´d like to show the picture a week ahead of the value in it´s date table. If,for example, the value i set to 2010-10-19, then a I would like it to be shown from today and expire 2010-10-20. I guess I have to deal with curdate(), or...?

<?php
$username = "";
$password = "";
$host = "";
$database = "";

@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());

@mysql_select_db($database) or die("Can not select the database: ".mysql_error());

$id = $_GET['show_date'];

if(!isset($id) || empty($id)){
die("There is no pic");
}else{

$query = mysql_query("SELECT * FROM nhto_gigpress_shows WHERE show_date ='".$id."'");
$row = mysql_fetch_array($query);
$content = $row['show_pic'];

header('Content-type: image/jpg');
echo $content;

}

?>

bradgrafelman

Instead of checking for equality, check to see if show_date is less than or equal to today's date.

pastra

bradgrafelman;10965587 wrote:
Instead of checking for equality, check to see if show_date is less than or equal to today's date.

Well, that make sense but still how do I make it print BETWEEN thoose dates mentioned above? Can I define it in the query with curdate(), BETWEEN and show_date? Please give me a hint with a code.

bradgrafelman

It's a simple inequality with the addition of MySQL's date mathematic syntax:

WHERE CURDATE() <= show_date + INTERVAL 1 WEEK

pastra

bradgrafelman;10965682 wrote:
It's a simple inequality with the addition of MySQL's date mathematic syntax:
WHERE CURDATE() <= show_date + INTERVAL 1 WEEK

Thanks for the tip about INTERVAL. This code above gave the result of all events equal or bigger then curdate. I wanted to have between to dates. I solved it with this:

WHERE `show_date` BETWEEN CURDATE() and DATE_ADD(CURDATE(), interval 1 WEEK) ORDER By show_date