thighmister Posted February 5, 2011 Share Posted February 5, 2011 The table is: next next_id id 0 2 1 1 3 2 0 4 3 0 1 4 The form: <?php include 'dbc.php'; page_protect(); if(!checkAdmin()) { header("Location: login.php"); exit(); } if($_POST['doSubmit'] == 'Create') { list($next_id) = mysql_fetch_row(mysql_query("select next_id from users where id='$id'")); mysql_query("update users set approved='1' where id='$id'"); mysql_query("update users set next='1' where id='$next_id'"); mysql_query("update users set next='0' where id='$id'"); list($to_email) = mysql_fetch_row(mysql_query("select user_email from users where id='$id'")); $ret = $_SERVER['PHP_SELF'] . '?'.$_POST['query_str']; header("Location: $ret"); exit(); $message = "Hello \n "; @mail($to_email, "Aaaaack", $message, "From: \"Lobo\" <auto-reply@$host>\r\n" . "X-Mailer: PHP/" . phpversion()); } ?> <html> <body> <table width="80%" border="0" cellpadding="5" cellspacing="2" class="myaccount"> <tr> <td>i<form name="form1" method="post" action="form.php"> <input name="doSubmit" type="submit" id="doSubmit" value="Create"> </p> </form> </td> </tr> </table> </body></html> I am sorry if this is posted in the wrong place! Here to learn. Thank you for any clues! Link to comment https://forums.phpfreaks.com/topic/226739-form-for-admin-to-update-2-rows-at-same-time-not-working/ Share on other sites More sharing options...
thighmister Posted February 6, 2011 Author Share Posted February 6, 2011 Sorry, I should have been more specific about "not working." I want the script to change the 'next' field to 0 for the logged in user, and change the 'next' field to '1' for the next user in line, as assigned by the 'next id' column. I also hoped it would send an email to the logged in user, but that's not as important. When I hit the "create" button, it does not change anything. There is no error message either. Link to comment https://forums.phpfreaks.com/topic/226739-form-for-admin-to-update-2-rows-at-same-time-not-working/#findComment-1170482 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.