Is this HTML in a print or echo statement? If not, then the variables will not display. You can View Source to verify this. ----- Original Message ----- From: "Steve Jackson" <[EMAIL PROTECTED]> To: "PHP General" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 8:27 AM Subject: [PHP] Problem updating
Been on this a couple of hours... anyone see what I'm doing wrong? I get a result of 1 when I echo $result but it doesn't want to update at all. The action of this form index.php?action=update-account is just a switch case Which asks you to use the function update_subscriber_account() below... <form method='post' action='index.php?action=update-account'> <input type='hidden' name='old_id' value='$email'> <tr> <th colspan = 2 bgcolor = '#5B69A6'> $title </th> </tr> <tr> <td>Real Name:</td> <td><input type = text name='new_realname' maxlength = 100 value ='$realname'></td> </tr> <tr> <td>Preferred Name:</td> <td><input type = text name='new_nickname' maxlength = 100 value ='$nickname'></td> </tr> <tr> <td>Company:</td> <td><input type = text name='new_company' maxlength = 100 value ='$company'></td> </tr> <tr> <td>Email Address:</td> <td><input type = text name='new_email' maxlength = 100 value ='$email'></td> </tr> <tr> <td>Requested Email Format:</td>"; echo "<td><select name='new_mimetype'><option"; if ($mimetype == 'T') echo " selected"; echo ">Text Only<option"; if ($mimetype == 'H') echo " selected"; echo ">HTML</select></td>"; print "</tr> <tr> <td colspan=2 align=center>"; display_form_button('save-changes'); print "</td></tr></form></table></center><br>"; } } function update_subscriber_account() { db_connect(); $query = "update subscribers set email = '$new_email', nickname = '$new_nickname', fullname = '$new_realname', company = '$new_company', mimetype = '$new_mimetype' where email = '$old_id'"; $result = mysql_query($query)or die("Error: Could not update query<BR>$query<BR>".mysql_error()); if (!$result) { echo "An error occurred when trying to update the DB"; } else { echo "$result & Successfully updated the details"; } } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php