problem with query

zuzupus

hi,

anybody plz let me know why data not inserts while running the query whats wrong in below piece of code

<?
$query = "SELECT hvorgangfrom emp_details ";
$result = mysql_query($query) or die("Query failed: $query");
$getrow=  mysql_fetch_array($result);
$hvorgang = array();
while ($row = mysql_fetch_assoc($result))
{
  array_push($hvorgang, $row"hvorgang");
}
$haupt = array_unique($hvorgang);

if (isset($HTTP_POST_REQUEST['add'])){
              mysql_query("INSERT into emp_details SET hvorgang = '{$HTTP_POST_REQUEST['hvorgang']}';");
             }

if (isset($HTTP_POST_REQUEST["remove"])){
mysql_query("DELETE from emp_details WHERE hvorgang = '{$HTTP_POST_REQUEST['hvorgang]}';");
} 
?>

<form>

<TR bordercolor="#FF6600">
<TD nowrap>Enter Option Name:
<input type="text" name="theText">
<select name="hvorgang">
<option value="">Option List</option>
<? foreach($haupt as $value) { ?>
<option value="<?= $value ?>" <? if ($HTTP_POST_VARS['hvorgang'] == $value){ echo "SELECTED";}?>><?= $value ?></option>
<? } ?>
</select>
<br>
<input type="button" onClick="updateList('add')" value="Add Item" name="add">
<input type="button" onClick="updateList('remove')" value="Remove Item" name="remove"> </TD>
</TR>
</form>

thanks anybody figure it out

Natty_Dreadlock

your query string is wrong this one is ok:

$query = "SELECT hvorgang FROM emp_details";

hth

zuzupus

thanks alot sorry for mistake 🙂

zuzupus

thanks for ur sincere advice and support for this post it alomost solved but when i add second field name uvorganag then it causing trouble when i enter any value in this field then its adding in drop down as well as adding empty space in first and second drop down,a wierd result
plz have a look for more clear what im trying to covince

http://server2.vitodesign.com/scripts/drop.phtml

if anybody help me out in this matter will be very helpful to mr as djerratik is in holiday till friday 🙂 and im not coming tomorrow
only on monday

thanks in advance


<?           include("../settings.php");
           /* Connecting, selecting database */
           $link = mysql_connect("$dbhost", "$dbuser", "$dbpw")
           or die("Could not connect");

       mysql_select_db("$dbuser") or die("Could not select database");

       if (isset($HTTP_POST_VARS['hadd'])){
           mysql_query("INSERT into emp_details SET hvorgang = '".$HTTP_POST_VARS['newhvorgang']."'");
           echo "added: ".$HTTP_POST_VARS['newhvorgang']."";
          }

       if (isset($HTTP_POST_VARS["hremove"])){
       mysql_query("DELETE from emp_details WHERE hvorgang = '".$HTTP_POST_VARS['hvorgang']."'");
       }
       /***if i remove these code then it works fine for h vorgang***/
       if (isset($HTTP_POST_VARS['uadd'])){
           mysql_query("INSERT into emp_details SET uvorgang = '".$HTTP_POST_VARS['newuvorgang']."'");
           echo "added: ".$HTTP_POST_VARS['newuvorgang']."";
          }

       if (isset($HTTP_POST_VARS["uremove"])){
       mysql_query("DELETE from emp_details WHERE uvorgang = '".$HTTP_POST_VARS['uvorgang']."'");
       }
       /***  ****************************************************  ***/

       $query = "SELECT hvorgang,uvorgang FROM emp_details ";
       $result = mysql_query($query) or die("Query failed: $query");
       $getrow=  mysql_fetch_array($result);
       $hvorgang = array();
       $uvorgang = array();

       while ($row = mysql_fetch_assoc($result))
       {
        array_push($hvorgang, $row["hvorgang"]);
        array_push($uvorgang, $row["uvorgang"]);
       }
            $haupt = array_unique($hvorgang);
            $unter = array_unique($uvorgang);


?>


<html>

<head>
<title>Beschreibung</title>
<link rel="stylesheet" type="text/css" href="../styles/styles1.css" />
      <script language="JavaScript" src="../JS/editdropdown.js"></SCRIPT>

</head>
      <body leftmargin="0" topmargin="0"  marginwidth="0" marginheight="0" bgcolor="#666666">
      <?



?>



<body>
<form name="theForm" action="" method="post">
                             <TR bordercolor="#FF6600">
                                 <TD nowrap>Enter Option Name:
                                  <input type="text" name="newhvorgang">
                                 <select name="hvorgang">
                                 <option value="">Option List</option>
                                 <? foreach($haupt as  $value) { ?>
                                 <option value="<?= $value ?>" <? if ($HTTP_POST_VARS['hvorgang'] == $value){ echo "SELECTED";}?>><?= $value ?></option>
                                  <? } ?>
                                 </select>
                                 <br>
                                 <input type="submit" value="Add Item" name="hadd">
                                 <input type="submit"  value="Remove Item" name="hremove"> </TD>

                           </TR> <br><br>
                           <!--if i remove this table uvorgang then it works normal for above table -->
                           <TR bordercolor="#FF6600">
                               <TD nowrap>Enter Option Name:
                                <input type="text" name="newuvorgang">
                               <select name="uvorgang">
                               <option value="">Option List</option>
                               <? foreach($unter as  $value) { ?>
                               <option value="<?= $value ?>" <? if ($HTTP_POST_VARS['uvorgang'] == $value){ echo "SELECTED";}?>><?= $value ?></option>
                                <? } ?>
                               </select>
                               <br>
                               <input type="submit"  value="Add Item" name="uadd">
                               <input type="submit"  value="Remove Item" name="uremove"> </TD>

                             </TR>
</form>
</body>

</html>