how to get a specific row in a large result set in mysql using php

When you work with a large result set you may need to get a specific row from the result set. When in a such situation you can use mysql_result().

$result = mysql_query('SELECT * FROM tbl_name');
echo mysql_result($result, 5); // output 6th row 

Get Free Sinhala IT Learning Videos Kuppiya.com

 Subscribe To My Blog