> > How is it possible to cycle through an SQL table row by row, without having
> > to increment an ID by 1 in a while loop and go
> > SELECT * FROM table WHERE id=$id
> > ?
> > And how can I find out how many rows are in the table?
> >
i hope this one can help you i'm using MySQL on my server
$sth = $dbh->prepare("Select * from TableName;");
$sth->execute;
$countrow = 0;
while(@FieldTable = $sth->fetchrow_array()) {
# Do Some Action Here;
$countrow++;
}
print "Total Existing Data on Table TableName = $countrow \n";
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
