--------------------------------------------------------
I have a table in MYSQL with the following fields.
SID -- Primary Key
SName
Username
Password
Principal Name
Telephone
Fax
Asian
Hispanic
Other
----------------------------------------------------------
Here is my Login Page
-----------------------------------------------------------
Code: Select all
<html>
<head>
<title>Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="login.php">
<p align="center"><strong><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif"><u>Login
Information</u></font></strong></p>
<p align="center"><font size="2" face="Arial, Helvetica, sans-serif"><strong>School
Name:
<input type="text" name="sname">
</strong></font></p>
<p align="center"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Password:
<input type="password" name="spass">
</strong></font></p>
<p align="center"><strong><font size="2">
<input type="submit" name="Submit" value="Submit">
</font></strong></p>
<p><br>
</p>
</form>
</body>
</html>IF I CLICK THE SUBMIT BUTTON THE FOLLOWING SHOULD HAPPEN.
I should be directed to a form with the SID for that particular username and password.
In that form all the values fro the fields must be displayed from the database.
For the Last 3 fields that are marked in Blue --- I should be able to enter new values and when i click the submit button, database should be updated and i should be displayed with the new values.
----------------------------------------------------------------
Here is my form .
------------------------------------------------------------------
Code: Select all
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>School Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="school.php">
<table width="75%" border="0" cellspacing="10" cellpadding="5">
<tr>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">School Name:</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield5">
</font></strong></td>
</tr>
<tr>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">Principal:
</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield22">
</font></strong></td>
</tr>
<tr>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">Telephone:</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield32">
</font></strong></td>
</tr>
<tr>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">Fax:</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield42">
</font></strong></td>
</tr>
<tr>
<td><strong><font color="#0000FF" size="2" face="Arial, Helvetica, sans-serif">Asian</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield">
% </font></strong></td>
</tr>
<tr>
<td><strong><font color="#0000FF" size="2" face="Arial, Helvetica, sans-serif">Hispanic</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield2">
% </font></strong></td>
</tr>
<tr>
<td><strong><font color="#0000FF" size="2" face="Arial, Helvetica, sans-serif">Other</font></strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="textfield3">
% </font></strong></td>
</tr>
<tr>
<td><strong>
<input type="submit" name="Submit" value="Submit">
</strong></td>
<td><strong><font size="2" face="Arial, Helvetica, sans-serif">
<input type="reset" name="Submit2" value="Reset">
</font></strong></td>
</tr>
</table>
<p> </p><p><br>
</p>
</form>
</body>
</html>WOULD APPRECIATE YOUR HELP.