[Resolved] How to get a specific row in a query

[turb]

Hi,

I know how to get the last row of a query result but what i'm trying to do is to get (i don't know how to write it in english) not the last, not before the last but the row before before the last row ... the third row starting with the last row .... something like that.

Can someone help me .... if someone understand my non-english explication 😉

turb

[sledgeweb]

$query = "Query";
$result = mysql_query($query);
$rows = mysql_num_rows($result);

$rowToGet = $rows - 3; //if 27 rows, will be 24
$var = mysql_result($result, $rowToGet, 'field');

Will that work for what you are doing?

[turb]

thank to reply ...

i also fonud another way :

$sql = "SELECT * FROM profile WHERE partCode LIKE '%x' ORDER BY partCode DESC LIMIT 2,1";

turb

[piersk]

Deleted the last two posts cos they repeated the above one.