limiting amount of rows displayed from database

[d3sol4t3]

Hi, how would i limit the amount of rows displayed from database?

Example

http://www.illworm.com/adm/main.php

look in the big green table in the middle of the page, the one where i have 10 rows saying 'How many rows'.

Say if i wanted to limit the amount displayed to 8, what code would i iimplement to do this.

Here is the current code being used for main.php:

http://www.illworm.com/main1.txt

**OPTIONAL**

Once 8 rows have been inserted, then the user click 'more...' which takes them to a page displaying all the news from that category from the past week.

For example:

http://www.addict3d.org/index.php?page=security

 

[jpadie]

to limit the number of rows to 8 add the words LIMIT 8 to the end of your sql query.

 

[jpadie]

and to do the second bit, have the more button add a queryvar to the end of the url

<a href="<?=$_SERVER['PHP_SELF']?>"?limit=none">more...</a>

and in your code test the value

if (isset($_GET['limit'])):
  $limit = $_GET['limit'] == "none" 
           ? "" 
           : "Limit ".$_GET['limit'];
endif;
$tablename = "";//name of table
$where = "" ; //where clause
$sql = "Select * from $tablename $where $limit";