Displaying only part of a mysql result set..?

[cranjled]

If I have a mysql result set in $thisVar that contains say 100 rows...and what I want to do is to display the rows as fields of a table...but only for rows that are greater than x and less than y.

When mysql results are gathered, does each row get an "id" number or something that could be used to tell if it's the 20th row or the 25th row that was returned?

Thanks,

Cranjled

[trogdor1024]

$startRow = 20;
$endRow = 30;
$i = 0;
$sel = mysql_query ("SELECT fieldname FROM table");
while (mysql_fetch_array($sel)) {
 if ($i > $startRow && $i <= $endRow) {
  echo $fet['fieldname'] . '<br />';
 }
 $i++;
} 

There is probably a better way to do that, but that should work too.

- Trog

[cranjled]

Thanks, that worked nicely.

[trogdor1024]

Excellent! No prob.

[swdev]

How about this

   $start_row = 19;
   $num_rows = 10;
   
   $sql = 'SELECT fieldname FROM table LIMIT ' . $start_row . ',' . $num_rows;
   $result = mysql_query($sql);
   while ($row = mysql_fetch_assoc($result))
   {
     echo $row['fieldname'] . '<br />';
   } 

In this scenario, you need to know the starting row (rows start from 0) and the numebr of rows you require.

For more info, look at http://dev.mysql.com/doc/mysql/en/SELECT.html

[cranjled]

Thanks to you too swdev.