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]