New Submissions

[NaOH]

Hi there,

 

I've got a photography portfolio, and I've written some code to query an SQL database for any photos submitted within the last week. The code is as follows:

 

<?php 
$host="localhost";
$username="******"; 
$password="******"; 
$database="******"; 
$siteurl="http://www.oxidephoto.ca";
$connection = mysql_connect($host, $username, $password);
$db = mysql_select_db($database);
$q = "SELECT * FROM `plogger_pictures` WHERE DATE_SUB(CURDATE(),INTERVAL 14 DAY) <= date_submitted";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$collection=$row["parent_collection"];
}

?>

 

This code exists within a while-db-has-pictures loop.

 

Also within this loop is the code to generate a 'NEW!' next to a new picture:

 

<?php if ($collection == plogger_get_collection_id()) {echo "NEW! ";} ?>

 

This works, technically, but the problem that I'm having is it does it to the most recent photo only, and if there's any others that apply (if I submit three in a day or something), they aren't highlighted.

 

I reckon that the problem is because $collection gets overwritten by the newest item grabbed each time, but I don't know how to correct this.  Any help would be greatly appreciated.

 

Thanks!

[Stooney]

This will just store it all in an array.

 

$count=0;
while ($row=mysql_fetch_array($result))
{
$collection[$count]=$row["parent_collection"];
$count++;
}