you may have a look on the php-manual for mysql functions, i nknow there is
a function to walk through the rows....
something like
SELECT * FROM `table` LIMIT 25 , 25
this means 25 records beginning with record 25
volker
----- Original Message -----
From: "someone human" <ahmed_abdelaliem@hotmail.com>
To: <php-db@lists.php.net>
Sent: Friday, May 16, 2003 2:19 AM
Subject: Help needed in maximum post per page
> Hi,
> i have a problem here,
> i am inserting data into mysql and retrieve it in a html table,
> i need to limit the posts only to be 50 row per page,
> how can i do that and how to make a link for the new pages that contains
th
> rest of the list (Link Next, Previuos or Page 1 | 2 | 3 ........)
> The query i am using to read the data is :
> <?
> @ $db = mysql_connect("localhost");
> mysql_select_db("egycds");
> $query = " SELECT * FROM newpcgames order by gameid desc";
> $result= mysql_query($query);
>
> while ($record=mysql_fetch_array($result)){
>
> echo "
> <TR bgColor=#475674>
> <TD width=75>
> <DIV align=center><FONT
> color=#ffffff>";
> echo stripslashes($record[date]) ;
> echo "</FONT></DIV></TD>
> <TD width=90>
> <DIV align=center><FONT color=white>";
> echo stripslashes($record[type]) ;
> echo "</FONT></DIV></TD>
> <TD><FONT color=#ffffff> <A
> href=\"";
> echo stripslashes($record[link]);
> echo "\" target=_new2>";
> echo stripslashes($record[name]);
> echo "</A> </FONT></TD>
> <TD width=50>
> <DIV align=center><FONT color=#ffffff>";
> echo stripslashes($record[cds]);
> echo "</FONT></DIV></TD> <TD width=80>
> <DIV align=center><FONT color=#ffffff>";
> echo stripslashes($record[rate]);
> echo "</FONT></DIV></TD>
>
> <TD width=70>
> <DIV align=center><FONT color=#ffffff><A
> href=\"";
> echo
stripslashes($record[downloaderlink]);
> echo "\">";
> echo stripslashes($record[downloader]);
> echo "</A></FONT></DIV></TD>
> <TD align=middle vAlign=center
> width=15><FONT
> color=#ffffff> </FONT></TD>
> </TR>
> ";
> }
> ?>
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
