curtime() and a different timezone

[CurtisKenny]

Hey, i've got a php script which uses mysql to get the current on air presenter for a website for a new community radio station website that im working on.

It has been working great until we moved to a server with a US Timezone.

Is there any way to offset the curtime() funtion by +6 hours?

My script code:

<?php 
$day = date('D');
$result = mysql_query("SELECT * FROM `$day` WHERE showbegin < curtime() AND showend > curtime()");

if(!$result){  
    echo "There has been an error in retrieving the current presenter. "; 
} else {
    $showInfo = mysql_fetch_assoc($result);
?>


<div class="show"> 
<p>Current Presenter: <?php echo $showInfo['presenter'] ?></p>
<?php } ?>

The script is liked up to a database with 7 tables (Mon, Tue, Wed, Thu, etc) and checks for the time from the showbegin and showend columns (data type set at time)

Thanks in advance
Curtis

[CurtisKenny]

I hate to bump my own thread (and im sorry if i broke the rules) but i think you cannot edit the curtime() timezone.

Can someone else suggest another way of pulling this sort of query from the database?

I thought about converting the current time into a decimal (as you can edit the timezone using php) and comparing it to the database. I tried this but got an error.

what do you think?

[Blinger1]

Couldn't you just do something like "$time = $curTime + 6" ? or some crap?

What i mean is, get the current time and just add 6 hours onto it?

[CurtisKenny]

i figured out how to do it!

I used: CURTIME() + 60000 which adds 6 hours

and for reference:

curtime()+100 adds 1 minute
curtime()+1000 adds 10 mins
curtime()+10000 adds an hour

[lick]

Well done to yourself

[Chippiewill]

I decided to clean up the code, it was just for practise and could be wrong:

 <?php  
$day = date('D'); 
$time = curtime() + 60000
$result = mysql_query("SELECT * FROM `$day` WHERE showbegin < $time AND showend > $time"); 

if(!$result){   
    echo "There has been an error in retrieving the current presenter. ";  
} else { 
    $showInfo = mysql_fetch_assoc($result); 
echo(' 
<div class=\"show\">  
<p>Current Presenter: $showInfo['presenter'] </p> '); 
}
?>

[Jam-ez]

I decided to clean up the code, it was just for practise and could be wrong:

$time = curtime() + 60000[b];[/b] 

You missed a colon, noticed instantly, can't be bothered to check the rest.

Oh, and you can't do:

echo(' 
<div class=\"show\">    
<p>Current Presenter: $showInfo['presenter'] </p> '); 
} 

Because it'd cut off the echo and then reopen it again.. which would fail. You'd have to do:

echo( " 
<div class='show'>  
<p>Current Presenter: $showInfo['presenter'] </p> " ); 
}