I'm trying to modify a script I'm using. I've gotten so far that it
displays my change and updates to old setting. I've added the required
field in the database and all setting but my new addition are being
updated.
Anyone sees anything strange here, or failing that what should I look
for in the code?
V e r b a l
8< -------------------------- c o d e ----------------------------->8
Now, in the snippets I've included below. There are several more of
these (<input lines are on one line rather than broken like here):
<tr>
<td width="50%" valign=center align=right>
<font size=3>Manage Users:</font>
</td>
<?
if ($u_manage_users==1) {
$manageusersgrant="checked";
}
else {
$manageusersdontgrant="checked";
}
?>
<td width="25%" valign=center align=center>
<input type="radio" name="u_manage_users" value="1" <?echo
$manageusersgrant;?>>
</td>
<td width="25%" valign=center align=center>
<input type="radio" name="u_manage_users" value="0" <?echo
$manageusersdontgrant;?>>
</td>
</tr>
// This is what I've included
<tr>
<td width="50%" valign=center align=right>
<font size=3>Manage Clients:</font>
</td>
<?
if ($u_manage_clients==1) {
$manageclientsgrant="checked";
}
else {
$manageclientsdontgrant="checked";
}
?>
<td width="25%" valign=center align=center>
<input type="radio" name="u_manage_clients" value="1"
<? echo $manageclientsgrant;?>>
</td>
<td width="25%" valign=center align=center>
<input type="radio" name="u_manage_clients" value="0"
<? echo
$manageclientsdontgrant;?>>
</td>
</tr>
// Ends my addition
The update is (as I understand) called by this statement ..
<p align=center>
<center>
<input type="submit" value="Next >>"
name="cmdSelectDepartments">
</td>
</center>
And the routine called cmdSelectDepartments
looks like this:
if(isset($cmdSelectDepartments)) {
$query = "UPDATE security SET ";
$query .= "s_firstname='$txtFirstname', ";
$query .= "s_lastname='$txtLastname', ";
$query .= "s_password='$txtPassword', ";
$query .= "s_email='$txtEmail' ";
$query .= "WHERE s_user='$txtUsername';";
$mysql_result = mysql_query($query, $mysql_link);
if ($mysql_result) { }
$query = "UPDATE security SET ";
$query .= "s_register_new_tickets='$u_register_new_tickets', ";
$query .= "s_authorize_tickets='$u_authorize_tickets', ";
$query .= "s_assign_tickets='$u_assign_tickets', ";
$query .= "s_update_tickets='$u_update_tickets', ";
$query .= "s_delete_tickets='$u_delete_tickets', ";
$query .= "s_open_closed_tickets='$u_open_closed_tickets', ";
$query .=
"s_view_unauthorized_tickets='$u_view_unauthorized_tickets', ";
$query .=
"s_view_department_tickets='$u_view_department_tickets', ";
$query .= "s_add_categories='$u_add_categories', ";
$query .= "s_delete_categories='$u_delete_categories', ";
$query .= "s_add_departments='$u_add_departments', ";
$query .= "s_delete_departments='$u_delete_departments', ";
$query .= "s_manage_users='$u_manage_users', ";
$query .= "s_add_parts='$u_add_parts', ";
$query .= "s_manage_clients='$u_manage_clients' "; //my addition
$query .= "WHERE s_user='$txtUsername';";
$mysql_result = mysql_query($query, $mysql_link);
As I said. All other settings are being updated, but mine (marked //my
addition).
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
