How to reterive specified tows from MySql using PHP?

HI, I want to reterive only the specified row from the MySql DB using PHP. for example given query is : SELECT * FROM articles_insertion. I want reterive only the second row from the results. what method in PHP i have to use for this operation.

 

mysql_result()

 

http://in2.php.net/manual/en/function.mysql-result.php

i want to reterive the entire row. the row has many fields in it. but you specified method reterives only one value.

 

Try adding a LIMIT clause to the query, starting at row 1, and going the length of 1

'select * from articles_insertion limit 1,1'

(hopefully)