Id

if ($_GET['action'] == "add") {

echo '<form method="post" action="admincenter.php?site=shopcategories" enctype="multipart/form-data"> <select>';


$ergebnis = safe_query("SELECT * FROM ".PREFIX."shop_subcategories ORDER BY namesub");
   while($ds = mysql_fetch_array($ergebnis)) {
  echo '
  <option value="'.$ds['subcatID'].'">'.$ds['namesub'].'   </option>';
 }
 
 
 
   
echo '</select>';
echo'
<table cellpadding="4" cellspacing="0">
 <tr>
   <td>'.$_language->module['catname'].':</td>
   <td><input type="text" name="name" class="form_off" onfocus="this.className = \'form_on\';" onblur="this.className = \'form_off\';" /></td>
  </tr>
  <tr>
   <td>'.$_language->module['pic'].':</td>
   <td><input name="pic" type="file" /></td>
  </tr>
  <tr>
   <td>&nbsp;</td>
 
   <td><input type="submit" name="save" value="'.$_language->module['newcat'].'" /></td>
  </tr>
 </table>
</form>
';
}

if ($_POST['save']) {
safe_query("INSERT INTO ".PREFIX."shop_categories (catID, subcatID, name, pic) values ('', '$subcatID', '$name', '') ");

$id = mysql_insert_id();

   if ($pic['name'] != "") {
      move_uploaded_file($pic['tmp_name'], $filepath . $pic['name']);
      @chmod($filepath.$pic[name], 0755);

      $file_ext = strtolower(substr($pic['name'], strrpos($pic['name'], '.')));
      $file = $id . $file_ext;

      rename($filepath . $pic['name'], $filepath . $file);

      safe_query("UPDATE ".PREFIX."shop_categories SET pic='$file' WHERE catID='$id'");
   }
}

INSERT INTO `w_shop_categories` (`catID`, `subcatID`, `name`, `pic`) VALUES
(1, '', 'Assistent', '');