How do I fetch SQL data with a timestamp logic

<?php
header('Access-Control-Allow-Origin: *');

$host="localhost"; // Host name 
$username="username"; // Mysql username 
$password="password"; // Mysql password 
$db_name="database"; // Database name 
$tbl_name="scores"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Retrieve data from database 
$sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10";
$result=mysql_query($sql);

// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
echo $rows['name'] . "|" . $rows['score'] . "|";

// close while loop 
}

// close MySQL connection 
mysql_close();
?>[/code:17bhc8n1]

Any one with some ideas?
Maybe the SQL-king @korbaach has any ideas?

$time=time()[/code:absbjous]

now you're going to store [url=http://www.unixtimestamp.com/]Unix Timestamp[/url] to table

[img="http://lookpic.com/O/i2/1857/l8KtVWyq.png"]

ok...now in your get score php
[code:absbjous]// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Retrieve data from database 
$sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10";
$result=mysql_query($sql);[/code:absbjous]

you can add after [i]"mysql_select_db("$db_name")or die("cannot select DB");"[/i]

[code:absbjous]$time = 0;
$oneday = 86400;
$days = $_POST['days'];

if ($days > "0") { 
   $time=time()-( $oneday * $days);
}
// Retrieve data from database 
$sql="SELECT * FROM scores  WHERE time>$time ORDER BY  score DESC LIMIT 10";
$result=mysql_query($sql);[/code:absbjous]

[img="https://media.giphy.com/media/3oriNQUBv7CaPkshWM/giphy.gif"]

[url=https://app.box.com/s/kuj97nt7aea82krvp02rdapzoj9xwt9s]scoreDaysphp.capx[/url]