Delaying database results

[ryanwood4]

Hello,

 

How would I delay results by 10 minutes, using the below script. Not sure what I need to add to delay the results.

 

Each result has a datetime called date in the database.

 

<?php
	$con = mysql_connect("localhost","xxx","xxx");
	if (!$con)
		 {
  		die('Could not connect: ' . mysql_error());
  		}

	mysql_select_db("xxx", $con);

	$result = mysql_query("SELECT * FROM members ORDER BY date DESC limit 0,1");

	while($row = mysql_fetch_array($result))
	{
		 echo '<img class="scaled" src="'.$row['image'].'"/><br />';
		 echo '<h3><a href="display/'.$row['id'].'">'.$row['title'].'</a></h3>';
	}

	mysql_close($con);
	?> 

 

Any help is greatly appreciated.

Thanks in advance.

[Mchl]

What do you mean by 'delay results by 10 min'

[ryanwood4]

What do you mean by 'delay results by 10 min'

 

Well the script above displays results from the database immediately after they are added, however we want a delay of 10 minutes before results are displayed. Does that make sense?

[PFMaBiSmAd]

I suspect what you actually want is to only retrieve (match) rows WHERE their datetime is more than 10 minutes ago? Rows with a datetime 10 minutes ago or less would not be retrieved?

[ryanwood4]

I suspect what you actually want is to only retrieve (match) rows WHERE their datetime is more than 10 minutes ago? Rows with a datetime 10 minutes ago or less would not be retrieved?

 

That's a better way of putting it! That's exactly what I want to do.

[inversesoft123]

you can delay it by 10 mins.

 

$resulttime =  time() - $resultold[1];
$result = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE time='$resulttime' ORDER BY date DESC limit 0,1"));

[ryanwood4]

you can delay it by 10 mins.

 

$resulttime =  time() - $resultold[1];
$result = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE time='$resulttime' ORDER BY date DESC limit 0,1"));

 

Don't seem to be getting any results with that?

[PFMaBiSmAd]

That's because that query does not address what you stated.

 

What type of values are in your date column?

[ryanwood4]

That's because that query does not address what you stated.

 

What type of values are in your date column?

 

The format is (example): 2010-02-28 12:17:37

[inversesoft123]

 

If you have date — Format a local time/date time field in table. http://www.php.net/manual/en/function.date.php

[PFMaBiSmAd]

You would need a WHERE clause in your query -

 

WHERE date < DATE_SUB(NOW(),INTERVAL 10 MINUTE)

[ryanwood4]

You would need a WHERE clause in your query -

 

WHERE date < DATE_SUB(NOW(),INTERVAL 10 MINUTE)

 

Work's perfectly!

 

Thanks.