let say e.g : time saved in database is 6:00:00,
so when current time is equal to database time which is 6:00:00
it then display my stored value(e.g 40 (int) ) from database. which is : 40
so i need help out here when the value shows : 40 on exact 6:00:00 (time) but disappear after a second i want to be display this value for 30 more sec.after that a new value from database will come and diplay as the time goes to 6:00:30
hope friend you will help me out soon thank you below is the code of php file.
// First Connect to database
echo "<meta http-equiv='refresh' content='20'>";
$link = mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error()); // Connection starts here
mysql_select_db("$dbname") or die(mysql_error());
$sql = "SELECT * FROM datatable WHERE time = '$ctime' "; // simple sql example
echo $cdate;
echo "<br>";
echo $ctime;
$re = mysql_query($sql) or die(mysql_error()); // Here's where you'll get an error if the SQL is invalid.
while($row = mysql_fetch_array($re))
{ // Beganing 1
include("variables.php");
echo "<br>";
echo $row['value']; [size=14pt]// value to be displayed for 30Sec after displayed on site.[/size]
} //Closing 4
mysql_close($link);
// code ends here..