Insert Query

[Xtremer360]

Okay what I would like to know is for the query I want to make the default_news_id the same number as the id (auto increment) when it gets inserted into databasse. How would that look? Also the default_character_id will be the id of the first character selected in the selection drop down list and added to the ul.

code]if (isset ( $_POST ['submit2'] )) { // Handle the form.
      // Define the query.
      $password = md5($p); // Currently $p does not have a value
      $login = $_POST['login'];
      $p = $_POST['password'];
      $surname = $_POST['surname'];
      $firstname = $_POST['firstname'];
      $email = $_POST['email'];
      $aim = $_POST['aim'];
      $msn = $_POST['msn'];
      $forumid = $_POST['forumid'];
      $enabled = $_POST['enabled'];
      $isadmin = $_POST['isadmin'];
      
      $query = "INSERT INTO efed_handler (login, password, surname, firstname, email, aim, msn, forumid, enabled, isadmin, default_news_id) VALUES ('".addslashes($login)."', '".addslashes($p).", '".addslashes($surname).",'".addslashes($firstname).", '".addslashes($email).", '".addslashes($aim).", '".addslashes($msn).", '".addslashes($forumid).", '".addslashes($enabled).", '".addslashes($isadmin)."')";
      
      // Execute the query.
      if (@mysql_query ( $query )) {
         print '<p>The handler has been added.</p>';
      } else {
         print '<p>Could not add the entry because: <b>"' . mysql_error() . '"</b>. The query was '.$query.'.</p>';
      }
      
      mysql_close ();
   
   } 
    
    print '<h1 class="backstage">Handler Management</h1><br />';
    print '<h2 class="backstage">Add New Handler Account</h2><br />';
    print '<form name="addhandler" method="post" action="backstage.php" id="addhandler">';
    print '<table width="100%" class="table2">';
    print '<tr>';
    print '<td width="120" class="rowheading">Username:</td><td class="row3"><input type="text" name="login" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Password:</td><td class="row3"><input type="password" name="password" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Surname:</td><td class="row3">';
    print '<input type="text" name="surname" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Firstname:</td>';
    print '<td class="row3"><input type="text" name="firstname" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Email:</td>';
    print '<td class="row3"><input type="text" name="email" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">AIM:</td>';
    print '<td class="row3"><input type="text" name="aim" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">MSN:</td>';
    print '<td class="row3"><input type="text" name="msn" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Forum ID:</td>';
    print '<td class="row3"><input type="text" name="forumid" class="fieldtext490"></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Account:</td>';
    print '<td class="row3"><select name="enabled" class="selection"><option value="0">- Select -</option>';
    print '<option value="Active">Active</option><option value="Inactive">Inactive</option>';
    print '</select></td>';
    print '</tr>';
    print '<tr>';
    print '<td class="rowheading">Administrator:</td>';
    print '<td class="row3"><select name="isadmin" class="selection"><option value="0">- Select -</option>';
    print '<option value="2">No</option><option value="1">Yes</option>';
    print '</select></td>';
    print '</tr>';
    print '</table><br />';
    print '<input type="submit" value="Save Handler" class="button" name="addhandler"><br /><br />';
    print '<input type="submit" value="Return to Handler List" class="button200"><br /><br />';
print '<script type="text/javascript" src="ajax.js"></script>';
   print '<h2 class="backstage">Characters<br /><br />';
   print '<select name="characterid" class="dropdown" id="character_selection">';
   print '<option value="">- Select -</option>';
   $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";
   }
   print '</select><input type="button" value="Add" class="button"></h2><br />';
   print '<ul id="characterlist"></ul><br /></form>';  
    print '<h2 class="backstage"><form method="post"><input type="submit" value="Return to Main Menu" class="button200"></form></h2>';