--- "FLAHERTY, JIM-CONT" <[EMAIL PROTECTED]> wrote:
> foreach $row(@$array_ref) {
> my($num,$title,$media,$serial,$time,$class,$remarks,$custody,$loc,
> $format,$qty,$lab,$rew,$sta,$history5,$check) = @$rows;
>
> $history2 = $history5;
> $history2++;
>
> }
> $dbh2 =DBI ->connect($data_source,
o that directly in the SQL by using:
"update media1 set history5 = history5 + 1 where ... "
--Adam
- Original Message -
From: "FLAHERTY, JIM-CONT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 9:59 PM
Subject: What am I doing wr
|
| cc:
|
| Subject: What am I doing wrong... I want to increment a number in a DB
|
>---
I have a query to draw it out on my redhat 7.1 box with MySQL 3.23 and I
increment it and run update query . Some where it resets back to zero all
the time
the code
foreach $row(@$array_ref) {
my($num,$title,$media,$serial,$time,$class,$remarks,$custody,$loc,
$format,$qty,$lab,$rew,$sta,$hist
