How do I read _rowid values for each row returned by SELECT statement with
DBD::mSQL Select works fine with the statement, but I need to know the
_rowid values for each row read by $ref = $sth -> fetchrow_hashref()
$keyword = " ";
$acct_num = 0;
$rowid = 0;
print "\nSELECT * FROM $table WHERE ((banner_alt RLIKE '".$keyword."') AND
(banner_acct >= $acct_num) AND (banner_exp <> 0) AND (_rowid > $rowid))\n";
$sth = $dbh->prepare("SELECT * FROM $table WHERE ((banner_alt RLIKE
".$dbh->quote($keyword).") AND (banner_acct >= $acct_num) AND (banner_exp
<> 0) AND (_rowid > $rowid))");
$sth->execute();
while ($ref = $sth -> fetchrow_hashref())
{
#processing each row. How do (if I can) I get _rowid values?
}
Ideas appreciated,
Roman Melihhov
-----------------------
http://www.blakout.net/
All that yo...
1 message in com.mysql.lists.perlreading _rowid value
