I think the right thing would be:
> $ki="UPDATE table1 SET name= 'ok5' where id=4 "
> $st=$dbh->prepare($ki);
$st -> execute;
$st->finish;
#
# You do not need to finish the handler if you re-use it
# use $st again (makes the code more raedable)
#
> $sth= $dbh -> prepare ("SELECT id,name,phone,data from $table order by id") or
die
> "Cannot SELECT from '$table'" ;
> $sth -> execute ;
while (@dat = $sth->fetchrow_array) {
...
}
$sth->finish;
$dbh->disconnect;
Regards, Gerhard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]