creating page number

[raffael3d]

I want that in the "while" it always adds one more page, so I would get:
pages: 1, 2, 3 , 4

I have this so far:

 while ($row = mysql_fetch_array($result))

{
  	$i = 1;
    print '<tr><td>';
	print "<a href=\"page.php>";
	print $i+1;
	print '</a>';
    print "</td></tr>";

      }

but it doesn't add while counting, how can I solve this? thanks.

[Frederick]

You need to establish your count start outside of the while()

$a = 1;
while ($row = mysql_fetch_array($sql)) {

echo "<tr>\n";
echo "<td>$a</td><td></td>\n";
echo "</tr>\n";

$a = $a + 1;

}

[raffael3d]

thanks a lot fred!

the problem I have now is, as results I get
3,5,7
why is that? I expected it to be 1,2,3,4,5,6,7

 <? $resultx = mysql_query("select * from dp_fragen order by id desc limit 7") or die ("could not read news database");

  $a = 1; 
  while ($row = mysql_fetch_array($resultx))

{


	print "<a href=\"page.php>";
	print $a = $a+1;
	print '</a>';


      }

[mrhappiness]

print $a = $a + 1;

prints the new value of $a, that is after having added 1

try

print $a++;

instead

[raffael3d]

thanks!

but now I get 2,4,6 instead.

I still need

1,2,3,4,5,6,7

:-9

[mrhappiness]

than i suppose you don't work with the code you posted above?

please poste the while loop you really use

do you change $a somewhere else?

[tekky]

you may want to view source on your HTML.... it may be caused by a quoting issue you have...

 <? $resultx = mysql_query("select * from dp_fragen order by id desc limit 7") or die ("could not read news database");

  $a = 1; 
  while ($row = mysql_fetch_array($resultx))

{

//---------------------Vhere and V here... add a \" after .php        

		print "<a href=\"page.php>";
		print $a = $a+1;
		print '</a>';


      }

[raffael3d]

thanks guys, indeed the quoting caused the problem.

solved now, thanks again everybody.

[tekky]

Originally posted by raffael3d
thanks guys, indeed the quoting caused the problem.

solved now, thanks again everybody.

cool, glad it was something simple

dont forget to mark this resolved 😉

[nem]

would you be able to post the full code please :rolleyes:

Sounds stupid i know, and maybe rude but i need something like this also :$

[raffael3d]

sure, what I used is:

$a = 1;
$i = 1;
while ($row = mysql_fetch_array($resultx))

{


	print "<a href=?pager=" . $i++ . ">";
	print $a++;
	print '</a>';


      }

[nem]

thanks dude