Making multiple rows with one query

Posted on 16th Feb 2014 07:03 pm by admin

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?
Code: <?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>&nbsp;&nbsp;<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);

}
}
?>

Your Answer:

Login to answer

Other forums

Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH

unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_
Can anyone view my code and tell me why im getting the error:
Parse error: syntax error, unexpect

if else problem, help please
i have this script that i made only i try to also put in a if else for for some reason the script is

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

PHP Include w/If IE Condition Statement?
I was having a problem with Internet Exploder (big surprise, right?) displaying my drop down menus i

How can you detect variable string in a massive string?
Ok guys, i need some help with this one.

I am going to be getting a large string, like 10-20

Phase Error I can't seem to find :(`
Hey guys, I can seem to find my phase error on this. I am getting this error

[error]
Pars