How To Get Specific Rows From Result Object

[JustinK101]

Assuming I have a result object:

 

$result = mysqli_query($sql_string);

 

How can I get specific rows, i.e. multiple rows are returned 8 total, but I was rows 2-6. Thanks.

[JustinK101]

I came up with this. Any better way?

 

$start_row = 2;
$end_row = 6;

$temp_rows = array();
$rows = array();

while($row = mysqli_fetch_object($result_obj)) {
     $temp_rows[] = $row;
}

for($i = $start_row; $i < $end_row; $i++) {
     $rows[] = $temp_rows[$i];
}

print_r($rows);

[ignace]

LIMIT 2, 4

 

http://dev.mysql.com/doc/refman/5.1/en/select.html

[JustinK101]

Yeah, cant do it at the db level, need to do in application code.