PHP Code:

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("eforum", $con);
$result = mysql_query("SELECT * FROM submitissue");
echo "<table border='1'>
<tr>
<th>Issue Creator</th>
<th>Issue Owner</th>
<th>Issue Description</th>
</tr>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['icr'] . "</td>";
  echo "<td>" . $row['io'] . "</td>";
  echo "<td>" . $row['id'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>

ive enter few data in it,and this code display only a few of the data,can i create a view button next to the tabla when we view the query.the view button will open up the full detail of a data

cheers

you can use limit statement like this

"SELECT * FROM submitissue limit=0,10"