New Submissions
Posted: Sat Dec 22, 2007 8:33 pm
scottayy | Please use
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:
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!
scottayy | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
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:Code: Select all
<?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"];
}
?>Also within this loop is the code to generate a 'NEW!' next to a new picture:
Code: Select all
<?php if ($collection == plogger_get_collection_id()) {echo "NEW! ";} ?>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!
scottayy | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]