Page 1 of 1

Please Help

Posted: Tue Aug 31, 2004 10:29 am
by Kingo
Please help me out with the following problem.

--------------------------------------------------------
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>&nbsp;</p><p><br>
  </p>
  </form>
</body>
</html>

WOULD APPRECIATE YOUR HELP.

Posted: Tue Aug 31, 2004 11:31 am
by feyd
what's your actual problem? You never stated it.