Dear Dan,
I don't know if I understood what you really want. Therefore I will try to help, ok.
I use Postgres as Database.
You can find out how many rows have in a table after you run a SQL like this.
#!/usr/bin/perl
use Pg;
$db = Pg::connectdb("dbname=database");
# This is a way to do it.
$result = $db->exec("SELECT * FROM table;");
$number_of_row = $result->ntuples;
print $number_of_row;
# This is another way to do it.
$result = $db->exec("SELECT count(*) FROM table;");
$number_of_row = $result->getvalue(0, 0);
print $number_of_row;
Best regards,
Na Sunday, 29 de September de 2002 �s 09:44:40 PM, dan escreveu:
> 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?
>
> Dan
>
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
Cleiton L. Siqueira
Col�gio Monjolo
[EMAIL PROTECTED]
(0xx45) 520-1915
Esta mensagem foi enviada pelo sistema MONJOLO WEBMAIL
http://www.colegiomonjolo.com.br
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
