Show content in the future?

[KvickaN]

Hello!

 

I've managed to solve that the content is shown AFTER 6 hours when added to the SQL. But I want to add many things on the same (current time) but I don't want everything to pop up after 6 hours. I want a 6 hour delay on EACH content I add. How do I solve this?

 

Here is my code:

 

$six_hours_ago = time() - 21600;
$sql = "SELECT * FROM Trailers WHERE Genre LIKE '%".$_GET['show']."%' AND time < '".$six_hours_ago."' ORDER BY `Trailers`.`sort` DESC";

 

insert.php

$sql="INSERT INTO Trailers (Poster, Title, Year, Genre, IMDB, Actors, Plot, Youtube, time)
VALUES
('".mysql_real_escape_string($_POST['Poster'])."','".mysql_real_escape_string($_POST['Title'])."','".$_POST['Year']."','".mysql_real_escape_string($_POST['Genre'])."','".$_POST['IMDB']."','".mysql_real_escape_string($_POST['Actors'])."','".mysql_real_escape_string($_POST['Plot'])."','".$_POST['Youtube']."', '".time()."')";

 

Thanks!

[requinix]

Add a field to your form for how long (minutes, hours, days, whatever) to wait until it's available. Then change the table to have two time fields: one for when the thing was actually created, and one for when it should "pop up".

 

Change your INSERTs and SELECTs appropriately...

[KvickaN]

Add a field to your form for how long (minutes, hours, days, whatever) to wait until it's available. Then change the table to have two time fields: one for when the thing was actually created, and one for when it should "pop up".

 

Change your INSERTs and SELECTs appropriately...

 

Brilliant! Thanks alot!