Ok now that I have the statistics piece done, I am working on the Modify Profile pages.
My site uses sessions to keep track of members, such as when they want to view their profile, it knows who they are.
NOW, the problem is that I have constructed a Modify Profile page that is not working! I wanted the HTML form to display the members profile and they just click on a checkbox and change the information that is displayed in the box to the right. Simple right? NOPE!
Sionce this application is like over 800 lines I will spare every single instance of code and give snippets of each one.
I am not getting an error, it is just not updating the rows at all.
<b>THE FORM:</b>
($ID is a session variable that identifies their profile)
The database connection and everything has already been made at this point
<form method='post' action='http://www.mysite.com/TEST/modifypro.php?varpass=$ID'>
<table width='75%' border='1' height='37'>
<tr>
<td width='4%' height='10'> <font size='7' face='Arial, Helvetica, sans-serif'>
<input type='checkbox' name='chgpass' value='1'>
</font> </td>
<td width='43%' height='10'><font face='Arial, Helvetica, sans-serif'>Change
my <font color='#FF8000'>PASSWORD</font> to:</font></td>
<td width='53%' height='10'>
<p><font face='Arial, Helvetica, sans-serif'>
<input type='text' name='pass'value='$Array1[pass]'>
</font></p>
</td>
</tr>
<b>THE APPLICATION THAT PARSES THE FORM</b>
Database Connection and everything is done at this point
$MID = $varpass;
#########################################################################
GO THROUGH IF STATEMENTS TO DETERMINE WHAT DATA NEEDS TO BE UPDATED
#########################################################################
IF (chgpass=='1') {
$Query1 = "UPDATE $TableName1 SET pass='$pass' WHERE auth.auth_id='$MID'";
}
It goes through all the possible changes and then goes to a success page listing the results of the changes.
Can any of you see a mistake? I thought that this would have worked. 🙁
