Xtremer360 Posted December 17, 2009 Share Posted December 17, 2009 I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is supposed to do is get the id from the handler and then with each char(acter) is supposed to make a new record for each of them with that same handler id. I"m trying to figure out how this is done? <?php case 1: echo $e; require_once('../backstageconfig.php'); require_once('../backstagefunctions.php'); ?> <h1 class="backstage">Handler Management</h1><br /> <h2 class="backstage">Add New Handler Account</h2><br /> <form name="addnewhandler" method="post"> <input type="hidden" name="action" value="handler" /> <table width="100%" class="table2"> <tr> <td width="120" class="rowheading">Username:</td><td class="row3"><input type="text" name="login" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Password:</td><td class="row3"><input type="password" name="password" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Surname:</td><td class="row3"> <input type="text" name="surname" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Firstname:</td> <td class="row3"><input type="text" name="firstname" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Email:</td> <td class="row3"><input type="text" name="email" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">AIM:</td> <td class="row3"><input type="text" name="aim" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">MSN:</td> <td class="row3"><input type="text" name="msn" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Forum ID:</td> <td class="row3"><input type="text" name="forumid" class="fieldtext490"></td> </tr> <tr> <td class="rowheading">Account:</td><td class="row3"> <select name="enabled" class="selection"> <option value="0">- Select -</option> <?php $query = 'SELECT name,id FROM efed_list_status'; $result = mysql_query ( $query ); while ( $row = mysql_fetch_assoc ( $result ) ) { print "<option value=\"".$row['id']."\">".$row['name']."</option>\r"; } ?> </select></td> </tr> <tr> <td class="rowheading">Administrator:</td><td class="row3"> <select name="isadmin" class="selection"> <option value="0">- Select -</option> <option value="2">No</option><option value="1">Yes</option> </select></td> </tr> </table><br /> <input type="hidden" name="newadded" value="true"> <input type="submit" value="Save Handler" class="button" name="submit"></form><br /> <input type="submit" value="Return to Handler List" class="button200"><br /><br /> <h2 class="backstage">Characters<br /><br /><form method="post"><select name="characterid" id="characterid" class="dropdown"> <option value="0">- Select -</option> <?php $query = 'SELECT charactername FROM efed_bio'; $result = mysql_query ( $query ); while ( $row = mysql_fetch_assoc ( $result ) ) { print "<option value=\"".$row['charactername']."\">".$row['charactername']."</option>\r"; } ?> </select> <input type="hidden" id="chars" name="chars" value=""><input type="button" value="Add" class="button" onclick="WrestlerList()"></form></h2><br /> <ul id="characterlist"></ul><br /> <script type="text/javascript" language="javascript"> function WrestlerList() { var addWrestler = document.addwrestler.characterid.value; if (addWrestler) { document.getElementById("chars").value += addWrestler+","; document.getElementById("characterlist").innerHTML += "<li>" + addWrestler + "</li>"; return WrestlerList; } else { document.getElementById("characterlist").innerHTML += "<li>This handler does not have any characters assigned.</li>"; } } </script> </form> <?php returnmain(); break; } function handler() { if ((!empty($_POST['newadded']))) { $password = md5($password); $login = mysql_real_escape_string($_POST['login']); $p = mysql_real_escape_string($_POST['password']); $surname = mysql_real_escape_string($_POST['surname']); $firstname = mysql_real_escape_string($_POST['firstname']); $email = mysql_real_escape_string($_POST['email']); $aim = mysql_real_escape_string($_POST['aim']); $msn = mysql_real_escape_string($_POST['msn']); $forumid = mysql_real_escape_string($_POST['forumid']); $isadmin = mysql_real_escape_string($_POST['isadmin']); $enabled = mysql_real_escape_string($_POST['enabled']); $char_array = explode(",", $_POST['chars']); $query1 = "INSERT INTO `efed_handler` (surname,firstname,isadmin,login,password,enabled,aim,msn,forumid,email,fed_id,) VALUES ('".$surname."','".$firstname."','".$isadmin."','".$login."','".$password."','".$enabled."','".$aim."','".$msn."','".$forumid."','".$email."',1)"; mysql_query($query); $query1_id = mysql_insert_id(); $query2 = "INSERT INTO `efed_handler_characters` (handler_id, bio_id) VALUES (".$query1_id.", $char_array)"; mysql_query($query2); } } ?> Link to comment https://forums.phpfreaks.com/topic/185455-making-multiple-rows-with-one-query/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.