hello iam fresher in mysql.iam creating a php web page in which i display field of table.
i need is when i click on one displaying field on form , it must show the some required field data only.
ex.select field2,field3.... from table where field = filed5;
here is code for display.php form
-------------------------------------------------------------------------
$data = mysql_query("SELECT * FROM employee")
or die(mysql_error());
print "<table border=1 cellpadding=3 align=center frame=box>";
//print "<caption><em><h3> <u>detail from database</h3></u></em></caption>";
print "<tr>";
print "<td> S.no.</td>";
print "<th>Tender no</th>";
print "<th>Tender description</th>";
print "<th>Tender date</th>";
print "<th>last date</th>";
print "<th>comodity</th>";
$i=0;
while($info = mysql_fetch_array( $data ))
{
$i++;
Print "<tr>";
print "<td>".$i ."</td>";
print "<td><a href=".$info['tno'].">".$info['tno']. "</a></td> ";
//$d = $info['tno'];
//print "$d";
Print "<td> ".$info['tdesc'] . " </td> ";
print "<td>".$info['tdate']. "</td>";
Print "<td>".$info['ldate'] . "</td> ";
print "<td>" .$info['tncmdty']. "</td>";
}
Print "</table>";
mysql_close($data);
--------------------------------------------------------------------
in line - print "<td><a href=".$info['tno'].">".$info['tno']. "</a></td> ";
when i click on this hyperlink data of tno field in form.it should display rest of field same table.related to colums/row. in new page.
please suggest me code.
Edited 1 time(s). Last edit at 04/25/2012 10:49PM by centos123 centos.