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($p1, $p2);
> }oh.. that's better practice? OK. I'll take a look at it.. but as of now, bind_param works w/ the prepare in the loop.
