echo db_fetch array

jassh

hi there..
i just want to knwo is there any better way to display
the amount of data displayed / the amount of data..

well, perhaps the following code hopefully
will make put sense in my question..


if (mysql_num_rows($result) > 0) {

//$total row is produced by me previously doing an identical query, and count the number of rows

echo "(<b>$total_n_view of $totalrows</B> person)";
echo "<BR>";
echo "<BR>";
echo "<BR>";


while ($mydb_array = mysql_fetch_array($result)) {

$first_name = $mydb_array['f_name'];
$last_name = $mydb_array['l_name'];

$total_in_view++

echo "$total_in_view) $first_name, $last_name ";
echo "<BR>";
echo "<BR>";
        }

i was hoping that my result would display:

3 of 5 person

1) mike, shinoda
2) joe, han
3) Avril Lavigne

then when i press my next button to the next page,

i was hoping it would display:

5 of 5 person

4)DJ, Quebert
5)Mixmaster, Mayhem

Unfortunately,

it ends up like this

of 5 person

1) mike, shinoda
2) joe, han
3) Avril Lavigne

of 5 person

1)DJ, Quebert
2)Mixmaster, Mayhem

i know the numbering is not correct due to i'm calling variable
before it exist.

so how do i fix this??

any idea??

-jassh

ir4z0r

at first you have a typo: ...$total_n_view ... use in

how do you request "next page"? with a variable eg $subpage?

to get the right number in front, add this var multiplied with the
number of name per page

for example, 2nd page
4 = 1 + $subpage3
5 = 2 + $subpage3