for loop? while loop? no loop?!?

[diarmuid]

hey everybody,

i'm trying to figur out a way to determine how many rows are in a mysql table.

i figured i can use a for loop, i'm just not sure how to go about it, when using mysql :\

any insight would be a great help

[Papillon]

just use a while loop
make it check the returnvalue of the row, and aslong as it is valid the loop keeps going

Code: Select all

#something like this =)
set rows 0
while {$rowreturnvalue != {}} {
  incr rows
}