verN Posted March 14, 2007 Share Posted March 14, 2007 I have the following problem when each field gets updated a seperate message appears two, three times depnding on how many chnages were made to the form. Basically i have a form when the details can be updated by the user. for($i = 0; $i < sizeof($e); $i++) { $updateM_query = "UPDATE mailinglists SET emailAddress='$e[$i]' WHERE seminarID='$id' AND emailAddress='$old[$i]'"; $updateM_result=mysql_query($updateM_query,$dbc) or die (mysql_error()); //echo $updateM_query; // email addresss is inserted if (mysql_affected_rows() >= 1) { // Print a message. echo '<p class="error">The changes have been updated.</p><br />'; } } thanks in advnce Quote Link to comment Share on other sites More sharing options...
Barand Posted March 15, 2007 Share Posted March 15, 2007 I guess the first thing is to see what is in the the array $e echo '<pre>', print_r($e, true), '</pre>'; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.