On 2007-08-23 10:17:58 +0800, Ow Mun Heng wrote:
> Current method.. pseudo code.
>
> while (1)
> {
> $from_datetime = time;
> $to_datetime = time + $time_interval;
>
> $query = "select count(*) from table where time >= ? and time $sth = $dbh->prepare($query)
> $sth->execute($from_datetime, $to_
On Thu, 2007-08-23 at 08:26 +0100, Martin J. Evans wrote:
> I'm not sure why it is not working as you expect but you should move the
> prepare outside of the loop:
>
> $query = "select count(*) from table where time >= ? and time $sth = $dbh->prepare($query)
> while (1)
> {
> $sth->execute($p
Ow Mun Heng wrote:
Current method.. pseudo code.
while (1)
{
$from_datetime = time;
$to_datetime = time + $time_interval;
$query = "select count(*) from table where time >= ? and time $sth = $dbh->prepare($query)
$sth->execute($from_datetime, $to_datetime)
$from_datetime = $to_datetime;
}
Re
On Thu, 2007-08-23 at 10:17 +0800, Ow Mun Heng wrote:
> Current method.. pseudo code.
>
> while (1)
> {
> $from_datetime = time;
> $to_datetime = time + $time_interval;
>
> $query = "select count(*) from table where time >= ? and time $sth = $dbh->prepare($query)
> $sth->execute($from_datetime,
Current method.. pseudo code.
while (1)
{
$from_datetime = time;
$to_datetime = time + $time_interval;
$query = "select count(*) from table where time >= ? and time prepare($query)
$sth->execute($from_datetime, $to_datetime)
$from_datetime = $to_datetime;
}
Results:
1st time ran.. will have re