Time content change

JPAwlak

Is there a way to change part of a webpage by pulling a DB entry according to the time.

For example, if it's 2:00 PM on Friday, pull DB entry number 4.

Using PHP and MySQL.

bastien

assumption here is that you want to base this on the users local time (if you want server time, then just use the [man]TIME[/man]
function to determine the time and make the query

the best thing to do here is have small js function that gets the local users time and submit it back to you

this gives you a current date/time stamp and you can take that apart to get the hours and minutes to do the query on the next page to show the user the db data for that timeframe

JPAwlak

I need the function that will pull the DB entry, not just the time function.

bastien

note this uses 24 hour time so 4Pm is 16
all in one page....
<?
//test for hours query
if (!$POST['thetime']){
getTime();
}else{
$time=$POST['thetime'];
if (!is_numeric($time)){
echo "there is an error";
}else{
//since the time function in javascript is able to get the hours we use that
echo "time is : $time";
$sql="select * from table where hour=$time";
echo "<br>$sql";
$result=mysql_query($sql) or die ("can;t connect to db");
}
}

function getTime()
{

echo "<html><script langauge=\"javascript\">
function GetTime(){
var mytime = new Date();
var myhrs = mytime.getHours();
mytime=myhrs;
document.time.thetime.value=mytime+1;
time.submit();
}
</script>
<body onload=\"GetTime();\">
<form name=time method=post action=testhours.php>
<input type=hidden name=thetime>
</form>
</body></html>
";
}//end function