Echo specific rows number from a mysql database

[tazeha]

Hello

 

In mysql is 50 row, example: id = 1,2,3,4,5,...

 

I want echo only row 5 until 20 how can I?

 

my code

foreach ( $result as $row ) {			 $data .='<tr>';		 $data .= '<td>'.$row->Shakhes.'</td>';		 $data .='<td>'.$row ->Value.'</td>';		 $data .='<td>'.$row ->TopValue.'</td>';		 $data .= '<td>'.$row->DownValue.'</td>';		 $data .= '<td>'.$row->Difference.'</td>';		 $data .='</tr>'.PHP_EOL;			 }

[thescientist]

You could do it in the query using LIMIT

http://stackoverflow.com/questions/1252673/how-can-i-select-rows-in-mysql-starting-at-a-given-row-number

[tazeha]

Great thanks