here is my first codes...
<form method="post" action="intersection.php">
<TABLE border=0>
<tr>
<td>Section:</td>
<td colspan=4><input type="text" Name="section" value="System Admin" size=40></td>
</tr>
<tr>
<td>Subject:</td>
<td colspan=4><input type="text" Name="subject" size=40></td>
</tr>
<tr>
<td>To Users (E-mail Address):</td>
<td colspan=4><textarea name="email" cols="40" rows="3" WRAP=virtual></textarea></td>
</tr>
<tr>
<td>Date Completed:</td>
<td><input type="text" Name="date_completed" size=10 ></td>
</tr>
</table>
<br>
<BODY>
<INPUT TYPE="submit" VALUE="Submit To User and Assignor">
<input type="reset" value="Clear Requirement"> </FORM>
</BODY>
and this is my second scripts...
<?php
$query = "INSERT INTO inter_section (no, section, subject, date_assigned, date_completed, userid) " .
"VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";
$result = mysql_query($query);
mysql_connect("hostname", "username", "password");
mysql_select_db("login");
$query = "INSERT INTO inter_section VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";
$result = mysql_query($query);
?>
<head><title>Inter-section status report assign by development design</title></head>
<h3>INTER-SECTION STATUS REPORT ASSIGN BY DEVELOPMENT DESIGN</H3>
<body bgcolor="#E6E8FA" text="black">
<body>
<?php
mysql_connect("localhost","username","password");
mysql_select_db("login");
?>
<?php
$result = mysql_query("SELECT * FROM inter_section");
echo "<table border = '1' bgcolor='white'>\n";
echo "<tr>
<td>No.</td>
<td>Section</td>
<td>Subject</td>
<td>Date Assign</td>
<td>Date Completed</td>
</tr>\n";
while ($myrow = mysql_fetch_row($result))
{
echo "<tr><td>$myrow[0]</td><td>$myrow[1]</td><td><a href='$myrow[2]'>$myrow[2]</a></td>
<td>$myrow[3]</td><td>$myrow[4]</td></tr>\n";
}
echo "</table>\n";
?>
</body>
please help me how to insert the key in data and display it in the table........
thanks
