How to jump to a line in MySQL and view it

[Mythic_Fr0st]

Currently I do this to view the first line

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("chars", $con);
$result = mysql_query("SELECT * FROM chars");

$row = mysql_fetch_array($result);

if I type $row =mysql_fetch_array($result); it shows me the second line if I echo it...

How do I get it to pick a line say (line 36, instead of the next in line being 2, or 3 or 4)

so I dont have to type $row=mysql_fetch_array($result); one hundred times to view the line I want...

(how do I select a specific line in my rows)

understand?

[sneakyimp]

RTFM!

http://php.net/mysql_result

[NogDog]

Or mysql_data_seek().