Return ONLY the 2nd result set in a query?

[Punk Rock Geek]

I have a select query:

 

$query = mysql_query ("SELECT * FROM tablename where id=1");

 

I would like to specifically return the 2nd result as a variable.  How would I got about doing this?  I have tried this:

 

while ($row = mysql_fetch_array($query)) {
$result = $row[1][fieldname];
}

 

But it doesn't seem to do anything meaningful.  Help?

[joel24]

$query = mysql_query ("SELECT * FROM tablename where id=1 limit 1,1");

 

limit x, y

... first result is 0, so its saying start at the second result (x) and then get (y) rows