$link = mysql_connect("manas8x", "root","Manas8")or die(mysql_error());
$db_selected = mysql_select_db('admin')or die(mysql_error());
$query = 'SELECT m_id, m_fname,m_lname FROM admininfo';
$result = mysql_query($query)or die(mysql_error());
echo "Number of rows : ". mysql_num_rows($result) ;
echo"<hr color='#000000' width='100' align='left'>";
echo "Used data seek to access 1st row of : 0->3 series";
mysql_data_seek($result,0);
print_r(mysql_fetch_row($result));
//
echo "<br/>Used data seek to access 2nd row of : 0->3 series";
mysql_data_seek($result,1);
print_r(mysql_fetch_row($result));
//
echo "<br/>Used data seek to access 3rd row of : 0->3 series";
mysql_data_seek($result,2);
print_r(mysql_fetch_row($result));
//
echo "<br/>Used data seek to access 4th row of : 0->3 series";
mysql_data_seek($result,3);
print_r(mysql_fetch_row($result));
//for ($i; $i <= $result; $i++)
$x=mysql_data_seek($result,2);
echo"<br/>------(1) mysql_fetch_assoc with for loop----------";
echo "<table border='1' width='300' >\n";
echo "<tr><td>ID</td><td>First Name</td><td>Last Name</td></tr>";
for ($i=0; $i <= $result; $i++) {
if (!mysql_data_seek($result, $i)) { echo "Pointer at row no: $i <br/>";
echo "Cannot seek to row $i: " . mysql_error() . "\n";
continue;
}
if (!($row = mysql_fetch_assoc($result))) {
continue;
}
echo "<tr><td>".$row['m_id']. "</td>" . "<td>" . $row['m_fname'] . "</td>"."<td>". $row['m_lname'] . "</td></tr>";
}
echo "</table></body>\n";
//
echo"-------(2)mysql_fetch_assoc in reverse using for loop----------";
echo "<table border='1' width='300' >\n";
echo "<tr><td>ID</td><td>First Name</td><td>Last Name</td></tr>";
for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i: " . mysql_error() . "\n";
continue;
}
if (!($row = mysql_fetch_assoc($result))) {echo "fetched data $i <br/>";
continue;
}
echo "<tr><td>".$row['m_id']. "</td>" . "<td>" . $row['m_fname'] . "</td>"."<td>". $row['m_lname'] . "</td></tr>";
}
echo "</table></body>\n";
//
echo"-------(3)mysql_fetch_array using while loop----------";
$query = 'SELECT m_id, m_fname,m_lname FROM admininfo';
$result = mysql_query($query);
echo "<table border='1' width='300' >\n";
echo "<tr><td>ID</td><td>First Name</td><td>Last Name</td></tr>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
if($col_value==" " or $col_value==''){ echo "<td>NA</td>";} else {
echo "<td>$col_value</td>\n";}
}
echo "\t</tr>\n";
}
echo "</table></body>\n";
// Free resultset
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows<br/>";
mysql_free_result($result);
// Closing connection
mysql_close($link);?>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>mysql_data_seek function</title>
</head>
<body text="#000080" bgcolor="#C0C0C0">
</body>
</html>
