[Jolten]

Okay. I'm setting a featured image into a table.

This table gets queried and displays the image on the home page.

I want to be able to pick featured images at any time but I do not want the home page image updating immediately after I pick an image. I want to pick 5 images at once then have the query use each image for a day (24 hours).

Something like (and this is just complete guessing)

$dtm=date(Ymd);
$dt = "20050122"; //todays date
while ($results=mysql_fetch_object($query)){

if($dtm ==$dt){

display featured image

}

$dt++
}


BUT, I don't think I need a loop. I could be wrong.

Currently, without a loop, I've got the query working and displaying the last image added to the db table.

Here's what I've got:

$qrySQL="SELECT field0.*, field1.chrresult, field1.atoconid, field2.intcontid, field2.strimgname, field2.strusrid, field2.strimgtitle 
FROM field0, field1, field2 
WHERE field1.chrresult = 'y'  
AND field2.intcontid = field1.atoconid 
AND field2.strimgname = field0.strimgname 
ORDER BY field0.imgid DESC LIMIT 0,1";

$rs0=$DB_site->query($qrySQL);
$row0=mysql_fetch_object($rs0);
$strusrid=$row0->strusrid;
$strimgname =$row0->strimgname;
$fname="./path/$row0->strimgname";
$intcontid=$row0->intcontid;
$imgTitle=$row0->strimgtitle;
$imgID=$row0->atocontid;

field0.imgid is the auto-increment table I want to step through.

I may have had an epiphany. Could I set a small php loop to increment an integer every 24 hours, set a variable for this and then use that for the where clause in the query?

Not sure how I'd write the incrementing loop but that seems like it might work.