Problem with MySql Queries

Anon

I have a script that is supposed to update a user record. When the script is run it generates no errors, logs in fine, all of the variables are passed without any problems, however, I cannot get mysql to update the user record, I've added the code to the bottom, I would greatly appreciate any help that anyone can provide. Here is the code:

<?php
if ($special_action=="update") {
$link = mysql_connect("localhost", "$db_username", "$db_password") or exit("Could not connect to database");
mysql_select_db("$db_name") or die("Could not select database");
mysql_query("UPDATE khsgrad SET name_first='$name_first', name_middle='$name_middle', name_last='$name_last', email_pri='$email_pri', email_alt='$email_alt' WHERE email_pri='$edit_email'") or exit("Could not alter database information.");
mysql_query("UPDATE khsgrad SET msn='$msn', aol='$aol', icq='$icq', yahoo='$yahoo', p_address='$p_address', p_phone='$p_phone' WHERE email_pri='$edit_email'") or exit("Could not alter database information.");
mysql_query("UPDATE khsgrad SET p_city='$p_city', p_state='$p_state', p_zip='$p_zip', p_cell='$p_cell', s_name='$s_name', s_address='$s_address' WHERE email_pri='$edit_email'") or exit("Could not alter database information.");
mysql_query("UPDATE khsgrad SET s_phone='$s_phone', s_city='$s_city', s_state='$s_state', s_zip='$s_zip', s_cell='$s_cell' WHERE email_pri='$edit_email'") or exit("Could not alter database information.");
mysql_close($link);
echo "<CENTER><FONT COLOR=\"FF0000\"><B>Contact Record Updated!</B></FONT></CENTER><BR />";
}

$link = mysql_connect("localhost", "$db_username", "$db_password") or exit("Could not connect to database");
mysql_select_db("$db_name") or die("Could not select database");
$result = mysql_query("SELECT * FROM khsgrad WHERE email_pri='$edit_email' AND password1='$edit_password'") or die("canoot receive information.");
while ($row = mysql_fetch_array($result)) {
	$name_first = $row["name_first"];
	$name_middle = $row["name_middle"];
	$name_last = $row["name_last"];
	$email_pri = $row["email_pri"];
	$email_alt = $row["email_alt"];
	$msn = $row["msn"];
	$aol = $row["aol"];
	$icq = $row["icq"];
	$yahoo = $row["yahoo"];
	$p_address = $row["p_address"];
	$p_phone = $row["p_phone"];
	$p_city = $row["p_city"];
	$p_state = $row["p_state"];
	$p_zip = $row["p_zip"];
	$p_cell = $row["p_cell"];
	$s_name = $row["s_name"];
	$s_address = $row["s_address"];
	$s_phone = $row["s_phone"];
	$s_city = $row["s_city"];
	$s_state = $row["s_state"];
	$s_zip = $row["s_zip"];
	$s_cell = $row["s_cell"];
}
mysql_close($link); 

$spacer="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp";

?>
Welcome to your edit page <B><?php echo $name_first; ?></B>. <B><FONT SIZE="1">[ <A HREF="?location=delete&delete_email=<?php echo $edit_email; ?>&delete_password=<?php echo $edit_password; ?>">DELETE RECORD</A> ]</FONT></B><BR />
<BR />
<B>NOTE:</B> Leave any entries that do not apply to you blank.
<BR /><BR />
<FORM METHOD="GET" ACTION="index.php">
<INPUT TYPE="HIDDEN" NAME="location" VALUE="edit">
<INPUT TYPE="HIDDEN" NAME="edit_email" VALUE="<?php echo $edit_email; ?>">
<INPUT TYPE="HIDDEN" NAME="edit_password" VALUE="<?php echo $edit_password; ?>">
<INPUT TYPE="HIDDEN" NAME="action" VALUE="login">
<INPUT TYPE="HIDDEN" NAME="special_action" VALUE="update">
<CENTER>
<TABLE WIDTH="450" BORDER="0" CELLPADDING="4" CELLSPACING="0">
<TR>
<TD WIDTH="225"><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Full First Name:</B></FONT></TD>
<TD WIDTH="255"><INPUT TYPE="TEXT" NAME="name_first" VALUE="<?php echo $name_first; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Full Middle Name:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="name_middle" VALUE="<?php echo $name_middle; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Full Last Name:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="name_last" VALUE="<?php echo $name_last; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Primary Email Address:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="email_pri" VALUE="<?php echo $email_pri; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Alternate Email Address:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="email_alt" VALUE="<?php echo $email_alt; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>MSN Messenger:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="msn" VALUE="<?php echo $msn; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>AOL Instant Messenger:</B></TD>
<TD><INPUT TYPE="TEXT" NAME="aol" VALUE="<?php echo $aol; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>ICQ UIN:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="icq" VALUE="<?php echo $icq; ?>"></TD>
</TR>
<TR>
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Yahoo Instant Messenger:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="yahoo" VALUE="<?php echo $yahoo; ?>"></TD>
</TR>
<TR>
<TD COLSPAN="2" BGCOLOR="C0C0C0"><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Permanent Contact Information:</B></FONT></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Address:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_address" VALUE="<?php echo $p_address; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Telephone Number:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_phone" VALUE="<?php echo $p_phone; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Cell Number:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_cell" VALUE="<?php echo $p_cell; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>City:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_city" VALUE="<?php echo $p_city; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>State:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_state" VALUE="<?php echo $p_state; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Zip / Postal Code:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_zip" VALUE="<?php echo $p_zip; ?>"></TD>
</TR>
<TR>
<TD COLSPAN="2" BGCOLOR="C0C0C0"><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>School Contact Information:</B></FONT></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>School Name:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_name" VALUE="<?php echo $s_name; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Address:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_address" VALUE="<?php echo $p_address; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Telephone Number:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_phone" VALUE="<?php echo $p_phone; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Cell Number:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_cell" VALUE="<?php echo $p_cell; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>City:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_city" VALUE="<?php echo $p_city; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>State:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="s_state" VALUE="<?php echo $p_state; ?>"></TD>
</TR>
<TR BGCOLOR="F0F0F0">
<TD><FONT SIZE="2" FACE="Verdana, Arial, Times New Roman"><B>Zip / Postal Code:</B></FONT></TD>
<TD><INPUT TYPE="TEXT" NAME="p_zip" VALUE="<?php echo $p_zip; ?>"></TD>
</TR>
</TABLE>
<BR />
<INPUT TYPE="SUBMIT" VALUE="Edit Contact Record">
</CENTER>
</FORM>

sarahk

Try putting the update statements into strings first & printing out eg

$sqlstr = "UPDATE khsgrad SET name_first='$name_first', name_middle='$name_middle', name_last='$name_last', email_pri='$email_pri', email_alt='$email_alt' WHERE email_pri='$edit_email'";
echo $sqlstr . "<br>";
mysql_query($sqlstr) or exit("Could not alter database information.");

Then do you get the fail message or does it seem to work. I'd generally copy the $sqlstr from the browser and see what happens when I put it into mysql directly. You might get some different feedback. Your where clause might be failing so it thinks it is doing the job but getting 0 matches.

Do you need to be using addslashes()?
I would have thought so - eg
("UPDATE khsgrad SET name_first='" . addslashes($name_first) . "', name_middle='" . addslashes($name_middle) > "', name_last='" . addslashes($name_last) . "', email_pri='" . addslashes($email_pri) . "', email_alt='" . addslashes($email_alt) . "' WHERE email_pri='" . addslashes($edit_email) "'"