473,385 Members | 2,004 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > php > questions > notice: undefined index: scales ...but it is defined? :s

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Notice: Undefined index: Scales ...but it is defined? :S

Hey,

I'm thinking this is something simple, as I'm a PHP/Web Dev newb, been asked to develop an app for work, so I'm stumbling my way through this, any how, I get the error:

Notice: Undefined index: Scales in C:\wamp\www\TS\upload.php on line 31

Here is a bit of the code that declares it:

Expand|Select|Wrap|Line Numbers
  1. <p></p></div>
  2.       <p>&nbsp;</p>
  3.       <p>&nbsp;&nbsp;&nbsp; <strong>Scales:</strong></p>
  4.       <p>&nbsp;&nbsp; &nbsp;<textarea rows="6" cols="50" name="Scales"></textarea>&nbsp;</p>
  5.       <p>&nbsp;&nbsp; &nbsp;<strong>Comments:</strong></p>
  6.       <p>&nbsp;&nbsp; &nbsp;<textarea rows="6" cols="50" name="Comments"></textarea>&nbsp;</p>
  7.       <p>&nbsp;&nbsp; 

And the code in the upload.php file that calls it trying to upload it to the DB:

Calling it into a variable:
Expand|Select|Wrap|Line Numbers
  1. $Scales =  $_POST["Scales"];
  2.  
Uploading to DB:

Expand|Select|Wrap|Line Numbers
  1. if ( !( $database = odbc_connect( "tradespend", "chrisbwamp","")))
  2. die( "Could not connect to database" );
  3.  
  4. $headerSQL = odbc_prepare($database, "INSERT INTO WebForm (Action,WebID,StartDate,EndDate,RequestType,TSH1,TSH2,TSH3,TSH4,SoldTo,CustomerType,EndUserNames,Scales,Comments,Status,EnteredBy)
  5. VALUES('$action','$WebID','$sdate','$edate','$RequestType','$TSH1','$TSH2','$TSH3','$TSH4','$SoldTo','$CustomerType','$EndUserNames','$Scales','$Comments','$Status','$EnteredBy');" ); 
  6.  
  7. if (!odbc_execute( $headerSQL))
  8. {
  9. /* error */
  10. echo "<h1>Insert of Header data has failed! Please contact IThelpdesk@pintys.com and reference Chris Beach</h1>";
  11. //break;
  12. }
  13.  
I have a bunch of fields working this way, most work, and about 4 of them are giving the same error as above.

Any ideas?
Aug 16 '10 #1
22 2175
zorgi
431 Expert 256MB
Can you give us more of the code from your form? I guess first part of your pasted code is the form. It sounds as if things are not getting posted properly.
Aug 16 '10 #2
I warn you, it is not pretty, but thank you very much for replying!

Expand|Select|Wrap|Line Numbers
  1.  
  2. <?php
  3. session_start();  
  4. if(isset($_SESSION['loggedin']))
  5. {
  6.   if(($_SESSION['loggedin']) == 'true')
  7. {
  8.     // echo 'yes true';
  9. }
  10.      else
  11. header("location:login.php");
  12. // echo 'no not true';
  13. }
  14. else
  15. header("location:login.php");
  16. // echo 'no';
  17. ?>
  18.  
  19.  
  20.  
  21. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  22. <html><head><title>Trade Spend Request Form</title>
  23. <meta name="GENERATOR" content="MSHTML 8.00.6001.18928">
  24. <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
  25. <script>
  26. function getXMLHTTP() { //fuction to return the xml http object
  27.         var xmlhttp=false;    
  28.         try{
  29.             xmlhttp=new XMLHttpRequest();
  30.         }
  31.         catch(e)    {        
  32.             try{            
  33.                 xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
  34.             }
  35.             catch(e){
  36.                 try{
  37.                 xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
  38.                 }
  39.                 catch(e1){
  40.                     xmlhttp=false;
  41.                 }
  42.             }
  43.         }
  44.  
  45.         return xmlhttp;
  46.     }
  47.  
  48.  
  49.     function getCity($elementID,strURL) {        
  50.  
  51.         var req = getXMLHTTP();
  52.  
  53.         if (req) {
  54.  
  55.             req.onreadystatechange = function() {
  56.                 if (req.readyState == 4) {
  57.                     // only if "OK"
  58.                     if (req.status == 200) {                        
  59.                         document.getElementById($elementID).innerHTML=req.responseText;                        
  60.                     } else {
  61.                         alert("There was a problem while using XMLHTTP:\n" + req.statusText);
  62.                     }
  63.                 }                
  64.             }            
  65.             req.open("GET", strURL, true);
  66.             req.send(null);
  67.         }
  68.  
  69.     }
  70. </script>
  71. <script language="javascript"> 
  72. function toggle() {
  73.     var ele = document.getElementById("hiddenConditions");
  74.     var text = document.getElementById("displayText");
  75.     if(ele.style.display == "block") {
  76.             ele.style.display = "none";
  77.         text.innerHTML = "More";
  78.       }
  79.     else {
  80.         ele.style.display = "block";
  81.         text.innerHTML = "hide";
  82.     }
  83. } 
  84. </script>
  85.  
  86. <script language="javascript" type="text/javascript" src="datetimepicker.js"> 
  87. </script>
  88.  
  89.  
  90. <?php 
  91.  
  92.   //Function to Connect to Daisy, execute Sql SELECT statement, and convert results to an array as a return value
  93. function sqlSelect($daisySelect)
  94. {
  95.   //connect to a DSN, "daisy" 
  96. $conn = odbc_connect('daisy','chrisbwamp',''); 
  97. if ($conn) 
  98. { 
  99.   //The SQL statement that will query the database 
  100.   $query = $daisySelect; 
  101.  
  102.   //Perform the query 
  103.   $result=odbc_exec($conn, $query); 
  104.  
  105.   //Convert results to an array
  106.   while(odbc_fetch_row($result))
  107.   { 
  108.      for($i=1;$i<=odbc_num_fields($result);$i++)  
  109.           {
  110.              $selectArray[]=odbc_result($result,$i);
  111.           }
  112.   } 
  113. return $selectArray;
  114. }
  115.  else echo "ODBC not connected, please contact ITHelpdesk@pintys.com";  
  116. }
  117.  
  118. ?>
  119. <style>
  120. <!--
  121. h1 { font-family: Arial, sans-serif; font-size: 30px; }
  122. h2 { font-family: Arial, sans-serif; font-size: 18px; }
  123.  
  124. body,p,b,i,em,dt,dd,dl,sl,caption,th,td,tr,u,blink,select,option,form,div,li { font-family: Arial, sans-serif; font-size: 12px; }
  125.  
  126.  
  127. /* IE Specific */
  128. body, textarea {
  129.   scrollbar-3dlight-color: #DDDED6;
  130.   scrollbar-highlight-color: #FDE7A2;
  131.   scrollbar-face-color: #FABD05;
  132.   scrollbar-shadow-color: #CA9904;
  133.   scrollbar-darkshadow-color: #805B32;
  134.   scrollbar-arrow-color: #000000;
  135.   scrollbar-track-color: #F8EFE2;
  136. }
  137. /* END IE Specific */
  138.  
  139.  
  140. a.mainlink:link { text-decoration: none; color: #ffffff; font-family: Verdana, Arial, sans-serif; font-size: 10px; font-weight: bold; }
  141. a.mainlink:visited { text-decoration: none; color: #ffffff; font-family: Verdana, Arial, sans-serif; font-size: 10px; font-weight: bold; }
  142. a.mainlink:hover { text-decoration: underline; color: #ffffff; font-family: Verdana, Arial, sans-serif; font-size: 10px; font-weight: bold; }
  143. -->
  144.  
  145. </style>
  146.  
  147. </head>
  148. <body bgcolor="#ffffff">
  149. <p>
  150. <table border="0" cellspacing="1" cellpadding="3" width="780" bgcolor="#fabd05" 
  151. align=center>
  152.   <tbody>
  153.   <tr>
  154.     <td bgcolor="#fabd05">
  155.       <p align="center"><br><strong>&nbsp;<font size="7">Trade Spend Request 
  156.       </font></strong></p></td></tr>
  157.   <tr>
  158.     <td bgcolor="#fabd05">
  159.       <p align="center"><font 
  160.   color=#fabd05><strong></strong></font>&nbsp;</p></td></tr>
  161.   <tr>
  162.     <td bgcolor="#ffffff">
  163.       <form method="post" name="tradespend" 
  164.       action="upload.php">
  165.       <p>&nbsp;</p>
  166.       <fieldset 
  167.       style="Z-INDEX: 0; WIDTH: 360px; HEIGHT: 75px; LEFT: 146px"><legend>Web 
  168.       Form:</legend>
  169.       <p>&nbsp;&nbsp;&nbsp;&nbsp;<strong>Action:</strong> <select 
  170.       style="Z-INDEX: 0; TOP: 237px; LEFT: 209px" size=1 name=Action><option 
  171.         selected value=Create>Create</option> <option value="Edit">Edit</option> 
  172.         <option value="Display">Display</option> <option 
  173.         value=Delete>Delete</option> 
  174.       &lt;\SELECT&gt;</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Web 
  175.       ID:</strong> <input style="Z-INDEX: 0; TOP: 236px; LEFT: 360px" 
  176.       name=WebID></p></fieldset> 
  177.       <p>&nbsp;&nbsp;&nbsp;<strong>Start Date:</strong>&nbsp;&nbsp;&nbsp; <input 
  178.       style="WIDTH: 78px; HEIGHT: 22px" id=sdate size=10 name=sdate><a 
  179.       href="javascript:NewCal('sdate','ddmmyyyy')"><img border="0" 
  180.       alt="Pick a date" src="cal.gif" width=16 height=16></a> 
  181.       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>End Date:&nbsp; 
  182.       </strong>&nbsp;<input style="WIDTH: 78px; HEIGHT: 22px" id="edate" size="10" 
  183.       name=edate><a href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  184.       alt="Pick a date" src="cal.gif" width=16 height=16></a></p>
  185.       <p><strong>&nbsp;&nbsp;&nbsp; Request Type:</strong> <select size="1" 
  186.       name=RequestType><option selected value=New>New</option> <option 
  187.         value=Incremental/Change>Incremental/Change</option> 
  188.       &lt;\SELECT&gt;</select>&nbsp;&nbsp;&nbsp;&nbsp;</p>
  189.       <p>&nbsp;&nbsp;&nbsp; </p>
  190.       <p><strong>&nbsp;&nbsp;&nbsp;&nbsp;Trade Spend Hierarchy:</strong> </p>
  191.       <p>&nbsp;&nbsp;&nbsp;&nbsp;<select size="1" name="TSH1"><option selected 
  192.         value=test>test</option> &lt;\SELECT&gt;</select>&nbsp;&nbsp; <select 
  193.       size=1 name=TSH2><option selected value=test>test</option> 
  194.       &lt;\SELECT&gt;</select>&nbsp;&nbsp;<select size="1" name="TSH3"><option 
  195.         selected value=test>test</option> 
  196.       &lt;\SELECT&gt;</select>&nbsp;&nbsp;<select size="1" name="TSH4"><option 
  197.         selected value=test>test</option> &lt;\SELECT&gt;</select></p>
  198.       <p>&nbsp; &nbsp; <strong>Sold-to:</strong> <select size="1" 
  199.         name=SoldTo><option selected value=10000>10000</option> 
  200.       &lt;\SELECT&gt;</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Customer 
  201.       Type:</strong> <select size="1" name="CustomerType"><option selected 
  202.         value=Deleted>Deleted</option> <option value="Food Service">Food 
  203.         Service</option> <option value="Industrial">Industrial</option> <option 
  204.         value=Intercompany>Intercompany</option> <option 
  205.         value=Retail>Retail</option> &lt;\SELECT&gt;</select></p>
  206.       <p>&nbsp;&nbsp; &nbsp;<strong>End User Name(s):</strong></p>
  207.       <p>&nbsp; &nbsp; 
  208.       <textarea rows="6" cols="50" name="EndUserNames"></textarea>&nbsp;</p>
  209.       <p>&nbsp;&nbsp; &nbsp;<strong><font color="#454453" size="3" 
  210.       face=Verdana>Condition Records:</font></strong></p>
  211.       <hr>
  212.  
  213.       <p>&nbsp;&nbsp;&nbsp;&nbsp;<strong><em>Item 
  214.       Type</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  215.       <em>Material 
  216.       Number</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>Forecasted&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  217.       UOM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Discount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  218.       Unit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  219.       Program&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Start&nbsp;Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  220.       End 
  221.       Date<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  222.       Volume&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rate</em></strong></p>
  223.       <div id="div1">&nbsp;&nbsp; 
  224.  
  225.  
  226.  
  227.       <select size="1" name="itemType1" onChange="getCity('material1','findcity.php?itemType='+this.value)"><option selected 
  228.         value=""></option> <option value="Material">Material</option><option value="PH1">PH1</option> <option 
  229.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  230.         value=PH4>PH4</option> &lt;\SELECT&gt;</select>           
  231.        <span id="material1">
  232. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city1" id="city1">
  233.  </select>    </span>           
  234. <input style="WIDTH: 69px; HEIGHT: 22px" size="6" 
  235.       name=ForecastedVollume1><select size="1" name="UOM1"><option 
  236.         value=></option> <option value="Carton">Carton</option> <option value="KG">KG</option> 
  237.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="4" 
  238.       name=DiscountRate1><select size="1" name="Unit1"><option value=""></option> <option 
  239.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  240.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  241.         &lt;\SELECT&gt;</select><select style="width: 110px;" size="1" name="Program1"><option selected 
  242.         value=></option> <option 
  243.         value=1>Conditions: Price</option> <option 
  244.         value=2>Extra Charge</option> <option 
  245.         value=3>ZCS    Case/KG/%Discount</option> <option 
  246.         value=4>Fees (Lump Sum)</option> 
  247.         <option value=5>Special Promotion</option> 
  248.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="sdate1" 
  249.       size=10 name=sdate1><a href="javascript:NewCal('sdate1','ddmmyyyy')"><img 
  250.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  251.       style="WIDTH: 78px; HEIGHT: 22px" id=edate1 size=10 name=edate1><a 
  252.       href="javascript:NewCal('edate1','ddmmyyyy')"><img border="0" 
  253.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  254.  
  255.  
  256.             <select size="1" name="itemType2" onChange="getCity('material2','findcity.php?itemType='+this.value)"><option selected 
  257.         value=""></option> <option value="Material">Material</option><option value="PH1">PH1</option> <option 
  258.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  259.         value=PH4>PH4</option> &lt;\SELECT&gt;</select>    
  260.  
  261.        <span id="material2">
  262. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city2" id="city2">
  263.  </select>    </span>
  264.  
  265. <input style="WIDTH: 69px; HEIGHT: 22px" size="6" 
  266.       name=ForecastedVollume2><select size="1" name="UOM2"><option 
  267.         value=></option> <option value="Carton">Carton</option> <option value="KG">KG</option> 
  268.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="4" 
  269.       name=DiscountRate2><select size="1" name="Unit2"><option value=""></option> <option 
  270.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  271.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  272.         &lt;\SELECT&gt;</select><select style="width: 110px;" size="1" name="Program2"><option selected 
  273.         value=></option> <option 
  274.         value=1>Conditions: Price</option> <option 
  275.         value=2>Extra Charge</option> <option 
  276.         value=3>ZCS    Case/KG/%Discount</option> <option 
  277.         value=4>Fees (Lump Sum)</option> 
  278.         <option value=5>Special Promotion</option> 
  279.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="sdate2" 
  280.       size=10 name=sdate2><a href="javascript:NewCal('sdate2','ddmmyyyy')"><img 
  281.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  282.       style="WIDTH: 78px; HEIGHT: 22px" id=edate2 size=10 name=edate2><a 
  283.       href="javascript:NewCal('edate2','ddmmyyyy')"><img border="0" 
  284.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  285.  
  286.  
  287.        <select size="1" name="itemType3" onChange="getCity('material3','findcity.php?itemType='+this.value)"><option selected 
  288.         value=""></option> <option value="Material">Material</option><option value="PH1">PH1</option> <option 
  289.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  290.         value=PH4>PH4</option> &lt;\SELECT&gt;</select>    
  291.  
  292.        <span id="material3">
  293. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city3" id="city3">
  294.  </select>    </span>
  295.  
  296. <input style="WIDTH: 69px; HEIGHT: 22px" size="6" 
  297.       name=ForecastedVollume3><select size="1" name="UOM3"><option 
  298.         value=></option> <option value="Carton">Carton</option> <option value="KG">KG</option> 
  299.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="4" 
  300.       name=DiscountRate3><select size="1" name="Unit3"><option value=""></option> <option 
  301.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  302.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  303.         &lt;\SELECT&gt;</select><select style="width: 110px;" size="1" name="Program3"><option selected 
  304.         value=></option> <option 
  305.         value=1>Conditions: Price</option> <option 
  306.         value=2>Extra Charge</option> <option 
  307.         value=3>ZCS    Case/KG/%Discount</option> <option 
  308.         value=4>Fees (Lump Sum)</option> 
  309.         <option value=5>Special Promotion</option> 
  310.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="sdate3" 
  311.       size=10 name=sdate3><a href="javascript:NewCal('sdate3','ddmmyyyy')"><img 
  312.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  313.       style="WIDTH: 78px; HEIGHT: 22px" id=edate3 size=10 name=edate3><a 
  314.       href="javascript:NewCal('edate3','ddmmyyyy')"><img border="0" 
  315.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  316.  
  317.  
  318.  
  319.  
  320.       <select size="1" name="ItemType">
  321.       <option selected 
  322.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  323.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  324.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><?php
  325. $arrProductNum=sqlSelect("SELECT Material_ID + ' - ' + DESCRIPTION AS Expr1
  326. FROM VW_TradeSpend_Material ORDER BY Material_ID ASC");
  327. ?>
  328. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name=MaterialNumber> 
  329. <?php
  330. foreach($arrProductNum as $products) { 
  331.       echo'<option value="'.$products.'">'.ltrim($products,"0").'</option>'; } 
  332.       echo "</select>"; 
  333. ?> <input style="WIDTH: 69px; HEIGHT: 22px" size="6" 
  334.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  335.         value=Carton>Carton</option> <option value="KG">KG</option> 
  336.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="5" 
  337.       name=DiscountRate><select size="1" name="Unit"><option selected 
  338.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  339.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  340.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  341.         value=Classifications>Classifications</option> <option 
  342.         value=Go>Go</option> <option value="Here">Here</option> 
  343.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  344.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  345.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  346.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  347.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  348.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  349.  
  350.  
  351.  
  352.       <select size="1" name="ItemType"><option selected 
  353.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  354.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  355.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><?php
  356. $arrProductNum=sqlSelect("SELECT Material_ID + ' - ' + DESCRIPTION AS Expr1
  357. FROM VW_TradeSpend_Material ORDER BY Material_ID ASC");
  358. ?>
  359. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name=MaterialNumber> 
  360. <?php
  361. foreach($arrProductNum as $products) { 
  362.       echo'<option value="'.$products.'">'.ltrim($products,"0").'</option>'; } 
  363.       echo "</select>"; 
  364. ?> <input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  365.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  366.         value=Carton>Carton</option> <option value="KG">KG</option> 
  367.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  368.       name=DiscountRate><select size="1" name="Unit"><option selected 
  369.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  370.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  371.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  372.         value=Classifications>Classifications</option> <option 
  373.         value=Go>Go</option> <option value="Here">Here</option> 
  374.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  375.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  376.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  377.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  378.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  379.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  380.       <select size="1" name="ItemType"><option selected 
  381.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  382.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  383.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  384.       name=MaterialNumber><option selected 
  385.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  386.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  387.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  388.         value=Carton>Carton</option> <option value="KG">KG</option> 
  389.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  390.       name=DiscountRate><select size="1" name="Unit"><option selected 
  391.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  392.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  393.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  394.         value=Classifications>Classifications</option> <option 
  395.         value=Go>Go</option> <option value="Here">Here</option> 
  396.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  397.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  398.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  399.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  400.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  401.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  402.       <select size="1" name="ItemType"><option selected 
  403.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  404.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  405.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  406.       name=MaterialNumber><option selected 
  407.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  408.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  409.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  410.         value=Carton>Carton</option> <option value="KG">KG</option> 
  411.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  412.       name=DiscountRate><select size="1" name="Unit"><option selected 
  413.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  414.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  415.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  416.         value=Classifications>Classifications</option> <option 
  417.         value=Go>Go</option> <option value="Here">Here</option> 
  418.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  419.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  420.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  421.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  422.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  423.       alt="Pick a date" src="cal.gif" width=16 height=16></a> </div>&nbsp;&nbsp; 
  424.       <select size="1" name="ItemType"><option selected 
  425.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  426.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  427.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  428.       name=MaterialNumber><option selected 
  429.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  430.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  431.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  432.         value=Carton>Carton</option> <option value="KG">KG</option> 
  433.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  434.       name=DiscountRate><select size="1" name="Unit"><option selected 
  435.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  436.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  437.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  438.         value=Classifications>Classifications</option> <option 
  439.         value=Go>Go</option> <option value="Here">Here</option> 
  440.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  441.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  442.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  443.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  444.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  445.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp; 
  446.       &nbsp;<select size="1" name="ItemType"><option selected 
  447.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  448.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  449.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  450.       name=MaterialNumber><option selected 
  451.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  452.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  453.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  454.         value=Carton>Carton</option> <option value="KG">KG</option> 
  455.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  456.       name=DiscountRate><select size="1" name="Unit"><option selected 
  457.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  458.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  459.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  460.         value=Classifications>Classifications</option> <option 
  461.         value=Go>Go</option> <option value="Here">Here</option> 
  462.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  463.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  464.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  465.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  466.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  467.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  468.       <select size="1" name="ItemType"><option selected 
  469.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  470.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  471.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  472.       name=MaterialNumber><option selected 
  473.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  474.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  475.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  476.         value=Carton>Carton</option> <option value="KG">KG</option> 
  477.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  478.       name=DiscountRate><select size="1" name="Unit"><option selected 
  479.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  480.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  481.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  482.         value=Classifications>Classifications</option> <option 
  483.         value=Go>Go</option> <option value="Here">Here</option> 
  484.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  485.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  486.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  487.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  488.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  489.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  490.       <select size="1" name="ItemType"><option selected 
  491.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  492.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  493.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  494.       name=MaterialNumber><option selected 
  495.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  496.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  497.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  498.         value=Carton>Carton</option> <option value="KG">KG</option> 
  499.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  500.       name=DiscountRate><select size="1" name="Unit"><option selected 
  501.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  502.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  503.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  504.         value=Classifications>Classifications</option> <option 
  505.         value=Go>Go</option> <option value="Here">Here</option> 
  506.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  507.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  508.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  509.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  510.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  511.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  512.       <select size="1" name="ItemType"><option selected 
  513.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  514.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  515.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  516.       name=MaterialNumber><option selected 
  517.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  518.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  519.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  520.         value=Carton>Carton</option> <option value="KG">KG</option> 
  521.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  522.       name=DiscountRate><select size="1" name="Unit"><option selected 
  523.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  524.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  525.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  526.         value=Classifications>Classifications</option> <option 
  527.         value=Go>Go</option> <option value="Here">Here</option> 
  528.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  529.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  530.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  531.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  532.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  533.       alt="Pick a date" src="cal.gif" width=16 height=16></a> 
  534.       <div></div>
  535.       <div id="div2">&nbsp;&nbsp; <select size="1" name="ItemType"><option selected 
  536.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  537.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  538.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  539.       name=MaterialNumber><option selected 
  540.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  541.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  542.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  543.         value=Carton>Carton</option> <option value="KG">KG</option> 
  544.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  545.       name=DiscountRate><select size="1" name="Unit"><option selected 
  546.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  547.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  548.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  549.         value=Classifications>Classifications</option> <option 
  550.         value=Go>Go</option> <option value="Here">Here</option> 
  551.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  552.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  553.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  554.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  555.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  556.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  557.       <select size="1" name="ItemType"><option selected 
  558.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  559.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  560.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  561.       name=MaterialNumber><option selected 
  562.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  563.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  564.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  565.         value=Carton>Carton</option> <option value="KG">KG</option> 
  566.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  567.       name=DiscountRate><select size="1" name="Unit"><option selected 
  568.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  569.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  570.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  571.         value=Classifications>Classifications</option> <option 
  572.         value=Go>Go</option> <option value="Here">Here</option> 
  573.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  574.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  575.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  576.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  577.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  578.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  579.       <select size="1" name="ItemType"><option selected 
  580.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  581.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  582.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  583.       name=MaterialNumber><option selected 
  584.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  585.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  586.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  587.         value=Carton>Carton</option> <option value="KG">KG</option> 
  588.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  589.       name=DiscountRate><select size="1" name="Unit"><option selected 
  590.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  591.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  592.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  593.         value=Classifications>Classifications</option> <option 
  594.         value=Go>Go</option> <option value="Here">Here</option> 
  595.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  596.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  597.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  598.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  599.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  600.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  601.       <select size="1" name="ItemType"><option selected 
  602.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  603.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  604.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  605.       name=MaterialNumber><option selected 
  606.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  607.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  608.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  609.         value=Carton>Carton</option> <option value="KG">KG</option> 
  610.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  611.       name=DiscountRate><select size="1" name="Unit"><option selected 
  612.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  613.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  614.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  615.         value=Classifications>Classifications</option> <option 
  616.         value=Go>Go</option> <option value="Here">Here</option> 
  617.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  618.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  619.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  620.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  621.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  622.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  623.       <select size="1" name="ItemType"><option selected 
  624.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  625.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  626.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  627.       name=MaterialNumber><option selected 
  628.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  629.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  630.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  631.         value=Carton>Carton</option> <option value="KG">KG</option> 
  632.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  633.       name=DiscountRate><select size="1" name="Unit"><option selected 
  634.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  635.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  636.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  637.         value=Classifications>Classifications</option> <option 
  638.         value=Go>Go</option> <option value="Here">Here</option> 
  639.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  640.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  641.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  642.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  643.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  644.       alt="Pick a date" src="cal.gif" width=16 height=16></a> </div>&nbsp;&nbsp; 
  645.       <select size="1" name="ItemType"><option selected 
  646.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  647.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  648.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  649.       name=MaterialNumber><option selected 
  650.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  651.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  652.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  653.         value=Carton>Carton</option> <option value="KG">KG</option> 
  654.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  655.       name=DiscountRate><select size="1" name="Unit"><option selected 
  656.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  657.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  658.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  659.         value=Classifications>Classifications</option> <option 
  660.         value=Go>Go</option> <option value="Here">Here</option> 
  661.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  662.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  663.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  664.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  665.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  666.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp; 
  667.       &nbsp;<select size="1" name="ItemType"><option selected 
  668.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  669.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  670.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  671.       name=MaterialNumber><option selected 
  672.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  673.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  674.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  675.         value=Carton>Carton</option> <option value="KG">KG</option> 
  676.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  677.       name=DiscountRate><select size="1" name="Unit"><option selected 
  678.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  679.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  680.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  681.         value=Classifications>Classifications</option> <option 
  682.         value=Go>Go</option> <option value="Here">Here</option> 
  683.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  684.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  685.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  686.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  687.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  688.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  689.       <select size="1" name="ItemType"><option selected 
  690.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  691.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  692.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  693.       name=MaterialNumber><option selected 
  694.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  695.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  696.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  697.         value=Carton>Carton</option> <option value="KG">KG</option> 
  698.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  699.       name=DiscountRate><select size="1" name="Unit"><option selected 
  700.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  701.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  702.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  703.         value=Classifications>Classifications</option> <option 
  704.         value=Go>Go</option> <option value="Here">Here</option> 
  705.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  706.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  707.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  708.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  709.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  710.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  711.       <select size="1" name="ItemType"><option selected 
  712.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  713.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  714.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  715.       name=MaterialNumber><option selected 
  716.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  717.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  718.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  719.         value=Carton>Carton</option> <option value="KG">KG</option> 
  720.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  721.       name=DiscountRate><select size="1" name="Unit"><option selected 
  722.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  723.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  724.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  725.         value=Classifications>Classifications</option> <option 
  726.         value=Go>Go</option> <option value="Here">Here</option> 
  727.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  728.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  729.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  730.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  731.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  732.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  733.       <select size="1" name="ItemType"><option selected 
  734.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  735.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  736.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  737.       name=MaterialNumber><option selected 
  738.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  739.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  740.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  741.         value=Carton>Carton</option> <option value="KG">KG</option> 
  742.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  743.       name=DiscountRate><select size="1" name="Unit"><option selected 
  744.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  745.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  746.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  747.         value=Classifications>Classifications</option> <option 
  748.         value=Go>Go</option> <option value="Here">Here</option> 
  749.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  750.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  751.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  752.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  753.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  754.       alt="Pick a date" src="cal.gif" width=16 height=16></a> 
  755.       <p></p>
  756.       <div></div><a id="displayText" href="javascript:toggle();">More</a> 
  757.       <div style="DISPLAY: none" id="hiddenConditions">&nbsp;&nbsp; <select size="1" 
  758.       name=ItemType><option selected value=Material>Material</option> <option 
  759.         value=PH1>PH1</option> <option value="PH2">PH2</option> <option 
  760.         value=PH3>PH3</option> <option value="PH4">PH4</option> 
  761.       &lt;\SELECT&gt;</select><select size="1" name="MaterialNumber"><option 
  762.         selected value="10000 - Chicken Fingers">10000 - Chicken 
  763.         Fingers</option> &lt;\SELECT&gt;</select><input 
  764.       style="WIDTH: 69px; HEIGHT: 22px" size=7 name=ForecastedVollume><select 
  765.       size=1 name=UOM><option selected value=Carton>Carton</option> <option 
  766.         value=KG>KG</option> &lt;\SELECT&gt;</select><input 
  767.       style="WIDTH: 54px; HEIGHT: 22px" size=6 name=DiscountRate><select size="1" 
  768.       name=Unit><option selected value=Percent>Percent</option> <option 
  769.         value=KG>KG</option> <option value="Carton">Carton</option> <option 
  770.         value="Lump $">Lump $</option> &lt;\SELECT&gt;</select><select size="1" 
  771.       name=Program><option selected 
  772.         value=Classifications>Classifications</option> <option 
  773.         value=Go>Go</option> <option value="Here">Here</option> 
  774.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  775.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  776.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  777.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  778.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  779.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp; 
  780.       &nbsp;<select size="1" name="ItemType"><option selected 
  781.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  782.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  783.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  784.       name=MaterialNumber><option selected 
  785.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  786.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  787.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  788.         value=Carton>Carton</option> <option value="KG">KG</option> 
  789.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  790.       name=DiscountRate><select size="1" name="Unit"><option selected 
  791.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  792.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  793.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  794.         value=Classifications>Classifications</option> <option 
  795.         value=Go>Go</option> <option value="Here">Here</option> 
  796.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  797.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  798.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  799.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  800.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  801.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  802.       <select size="1" name="ItemType"><option selected 
  803.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  804.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  805.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  806.       name=MaterialNumber><option selected 
  807.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  808.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  809.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  810.         value=Carton>Carton</option> <option value="KG">KG</option> 
  811.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  812.       name=DiscountRate><select size="1" name="Unit"><option selected 
  813.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  814.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  815.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  816.         value=Classifications>Classifications</option> <option 
  817.         value=Go>Go</option> <option value="Here">Here</option> 
  818.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  819.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  820.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  821.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  822.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  823.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  824.       <select size="1" name="ItemType"><option selected 
  825.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  826.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  827.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  828.       name=MaterialNumber><option selected 
  829.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  830.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  831.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  832.         value=Carton>Carton</option> <option value="KG">KG</option> 
  833.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  834.       name=DiscountRate><select size="1" name="Unit"><option selected 
  835.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  836.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  837.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  838.         value=Classifications>Classifications</option> <option 
  839.         value=Go>Go</option> <option value="Here">Here</option> 
  840.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  841.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  842.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  843.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  844.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  845.       alt="Pick a date" src="cal.gif" width=16 height=16></a> &nbsp;&nbsp; 
  846.       <select size="1" name="ItemType"><option selected 
  847.         value=Material>Material</option> <option value="PH1">PH1</option> <option 
  848.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  849.         value=PH4>PH4</option> &lt;\SELECT&gt;</select><select size="1" 
  850.       name=MaterialNumber><option selected 
  851.         value="10000 - Chicken Fingers">10000 - Chicken Fingers</option> 
  852.         &lt;\SELECT&gt;</select><input style="WIDTH: 69px; HEIGHT: 22px" size="7" 
  853.       name=ForecastedVollume><select size="1" name="UOM"><option selected 
  854.         value=Carton>Carton</option> <option value="KG">KG</option> 
  855.       &lt;\SELECT&gt;</select><input style="WIDTH: 54px; HEIGHT: 22px" size="6" 
  856.       name=DiscountRate><select size="1" name="Unit"><option selected 
  857.         value=Percent>Percent</option> <option value="KG">KG</option> <option 
  858.         value=Carton>Carton</option> <option value="Lump $">Lump $</option> 
  859.         &lt;\SELECT&gt;</select><select size="1" name="Program"><option selected 
  860.         value=Classifications>Classifications</option> <option 
  861.         value=Go>Go</option> <option value="Here">Here</option> 
  862.       &lt;\SELECT&gt;</select><input style="WIDTH: 78px; HEIGHT: 22px" id="edate" 
  863.       size=10 name=sdate><a href="javascript:NewCal('edate','ddmmyyyy')"><img 
  864.       border=0 alt="Pick a date" src="cal.gif" width=16 height=16></a><input 
  865.       style="WIDTH: 78px; HEIGHT: 22px" id=edate size=10 name=sdate><a 
  866.       href="javascript:NewCal('edate','ddmmyyyy')"><img border="0" 
  867.       alt="Pick a date" src="cal.gif" width=16 height=16></a> 
  868.       <p></p></div>
  869.       <p>&nbsp;</p>
  870.       <p>&nbsp;&nbsp;&nbsp; <strong>Scales:</strong></p>
  871.       <p>&nbsp;&nbsp; &nbsp;<textarea rows="6" cols="50" name="Scales"></textarea>&nbsp;</p>
  872.       <p>&nbsp;&nbsp; &nbsp;<strong>Comments:</strong></p>
  873.       <p>&nbsp;&nbsp; &nbsp;<textarea rows="6" cols="50" name="Comments"></textarea>&nbsp;</p>
  874.       <p>&nbsp;&nbsp; 
  875.       &nbsp;<strong>Status:</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  876.       &nbsp;<input name="Status"></p>
  877.       <p>&nbsp;&nbsp;&nbsp; <strong>Entered By: </strong> <input 
  878.       name=EnteredBy value="<?php print $_SESSION['loggedinName'];?>"/></p>
  879.       <p>&nbsp;</p>
  880.       <p>&nbsp;</p>
  881.       <p>&nbsp;</p>
  882.  
  883.  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  884. <input value="Submit" type="submit" name="submit"><input value="Reset" type="reset" name="reset"> 
  885.       </form></p></td></tr>
  886.   <tr>
  887.     <td bgcolor="#ffffff">&nbsp;</td></tr></tbody></table></ P></p>
  888. <p>&nbsp;</p>
  889. <p>&nbsp;</p>
  890. <p>&nbsp;</p>
  891. <p>&nbsp;</p><font size="1"><font size="1"></font></a></p></font></font></body></html>
  892.  

And My Upload.php:

Expand|Select|Wrap|Line Numbers
  1. <?php
  2. //error_reporting(E_ALL ^ E_NOTICE);  
  3. //condition record variables
  4.  
  5. $sdates = array($_POST["sdate1"],$_POST["sdate2"],$_POST["sdate3"]);
  6. $edates = array($_POST["edate1"],$_POST["edate2"],$_POST["edate3"]);
  7. $itemTypes = array($_POST["itemType1"],$_POST["itemType2"],$_POST["itemType3"]);
  8. $citys = array($_POST["city"],$_POST["city2"],$_POST["city3"]);
  9. $ForecastedVolumes = array($_POST["ForecastedVollume1"],$_POST["ForecastedVollume2"],$_POST["ForecastedVollume3"]);
  10. $UOMS = array($_POST["UOM1"],$_POST["UOM2"],$_POST["UOM3"]);
  11. $DiscountRates = array($_POST["DiscountRate"],$_POST["DiscountRate2"],$_POST["DiscountRate3"]); 
  12. $Units = array($_POST["Unit1"],$_POST["Unit2"],$_POST["Unit3"]); 
  13. $Programs = array($_POST["Program1"],$_POST["Program2"],$_POST["Program3"]); 
  14.  
  15. //web form variables
  16.  
  17. $action = $_POST["Action"];
  18. $WebID = $_POST["WebID"];
  19. $sdate = $_POST["sdate"];
  20. $edate = $_POST["edate"];
  21. $RequestType = $_POST["RequestType"];
  22. $TSH1 = $_POST["TSH1"];
  23. $TSH2 = $_POST["TSH2"];
  24. $TSH3 = $_POST["TSH3"];
  25. $TSH4 = $_POST["TSH4"];
  26. $SoldTo = $_POST["SoldTo"];
  27. $CustomerType = $_POST["CustomerType"];
  28. $EndUserNames = $_POST["EndUserNames"];
  29. $Status = $_POST["Status"];
  30. $EnteredBy = $_POST["EnteredBy"];
  31. $Scales =  $_POST["Scales"];
  32. $Comments = $_POST["Comments"];
  33.  
  34. print_r($_POST);
  35.  
  36. function sqlSelect($daisySelect)
  37. {
  38.   //connect to a DSN, "daisy" 
  39. $conn = odbc_connect('daisy','chrisbwamp',''); 
  40. if ($conn) 
  41. { 
  42.   //The SQL statement that will query the database 
  43.   $query = $daisySelect; 
  44.  
  45.   //Perform the query 
  46.   $result=odbc_exec($conn, $query); 
  47.  
  48.   //Convert results to an array
  49.   while(odbc_fetch_row($result))
  50.   { 
  51.      for($i=1;$i<=odbc_num_fields($result);$i++)  
  52.           {
  53.              $selectArray[]=odbc_result($result,$i);
  54.           }
  55.   } 
  56. return $selectArray;
  57. }
  58.  else echo "ODBC not connected";  
  59. }
  60.  
  61.  
  62.  
  63.  
  64. // connect to ODBC
  65. if ( !( $database = odbc_connect( "tradespend", "chrisbwamp","")))
  66. die( "Could not connect to database" );
  67.  
  68. $headerSQL = odbc_prepare($database, "INSERT INTO WebForm (Action,StartDate,EndDate,RequestType,TSH1,TSH2,TSH3,TSH4,SoldTo,CustomerType,EndUserNames,Scales,Comments,Status,EnteredBy)
  69. VALUES('$action','$sdate','$edate','$RequestType','$TSH1','$TSH2','$TSH3','$TSH4','$SoldTo','$CustomerType','$EndUserNames','$Scales','$Comments','$Status','$EnteredBy');" ); 
  70.  
  71. if (!odbc_execute( $headerSQL))
  72. {
  73. /* error */
  74. echo "<h1>Insert of Header data has failed! Please contact IThelpdesk@pintys.com and reference Chris Beach</h1>";
  75. //break;
  76. }
  77. //else echo  "<h1>Header data was successfully uploaded to the database</h1>";
  78.  
  79. $stmt2=sqlSelect("SELECT MAX(WebID) FROM dbo.WebForm");
  80. print "the web ID is $stmt2[0]";
  81. // loop through the itemTypes, if they selected one, then insert that line into the database
  82. foreach ($itemTypes as $key => $value) {
  83. if ( $value != "" ) {
  84. /* run insert */
  85. print " $key";
  86. print " $value";
  87.  
  88.  
  89. $stmt = odbc_prepare($database, "INSERT INTO ConditionRecords (ItemType,Material,ForecastedVolume,UOM,DiscountRate,Unit,Program,StartDate,EndDate,HeaderKey)
  90. VALUES('$itemTypes[$key]','$citys[$key]','$ForecastedVolumes[$key]','$UOMS[$key]','$DiscountRates[$key]','$Units[$key]','$Programs[$key]','$sdates[$key]','$edates[$key]','1');" );
  91.  
  92. if (!odbc_execute( $stmt))
  93. {
  94. /* error */
  95. echo "<h1>Upload to database has failed!</h1>";
  96. //break;
  97. }
  98. else echo  "<h1>Trade Spend Request was successfully uploaded to the database</h1>";
  99.  
  100. }
  101. }
  102.  
  103. ?>
  104.  
Aug 16 '10 #3
zorgi
431 Expert 256MB
Woooooooooooow that is not pretty. I ignored it all, copy - pasted your code and submitted the form. It worked. So I guess the problem is somewhere in your upload.php. Can we see more of that code?
Aug 16 '10 #4
zorgi
431 Expert 256MB
I have trouble reproducing that error. What are 4 fields giving you that error?
Aug 16 '10 #5
Yeah, sorry for the ugliness :( My first time making a site, I used a form builder to lay everything out, unfortunately it did a messy job of formatting the HTML code.

These are the fields that fail:


Notice: Undefined index: city2 in C:\wamp\www\TS\upload.php on line 8

Notice: Undefined index: city3 in C:\wamp\www\TS\upload.php on line 8

Notice: Undefined index: edate in C:\wamp\www\TS\upload.php on line 20

Notice: Undefined index: Scales in C:\wamp\www\TS\upload.php on line 31

Notice: Undefined index: Comments in C:\wamp\www\TS\upload.php on line 32


...At least my upload.php is somewhat pretty? :D
Aug 16 '10 #6
Now I'm getting even more confused.

I changed around the code a bit. On my form, I have rows of drop downs and fields. The first 3 are correct, and getting data from the database, the rest were just place holders until I was sure everything was working.

Well, I replaced most of the place holders with the code from the first 3 rows of drop downs and input boxes (incrementing variable names with a number), and now when I submit the form, Comments and Scales does not give an undefined index error, and it now contains a value.

However, I still get:


Notice: Undefined index: city in C:\wamp\www\TS\upload.php on line 8

Notice: Undefined index: city2 in C:\wamp\www\TS\upload.php on line 8

Notice: Undefined index: city3 in C:\wamp\www\TS\upload.php on line 8

What are the typical reasons it isn't able to populate a variable using $_POST ? Do DIV's or any tags come into effect? I don't get why my city variables just plain don't work.
Aug 16 '10 #7
zorgi
431 Expert 256MB
Its very difficult to look through your code. Sometime the best way to do things is to do them from scratch or all over again. All I can see is that your city Select Boxes are probably not getting populated. You should have some sort of default value set for them in your HTML like:

Expand|Select|Wrap|Line Numbers
  1. <select name="city">
  2.     <option value="no city selected">---</option>
  3. </select>
  4.  
or an extra check in your Upload.php. Something like this:

Expand|Select|Wrap|Line Numbers
  1.   if(isset($_POST['city'])){
  2.     $city = $_POST['city'];
  3.   }else{
  4.     $city = "no city selected";
  5.   }
  6.  
Aug 16 '10 #8
Thanks for the reply, I've had some fires at work and couldn't come back until now.

It's definitely NOT setting the $_POST variable for the "city" drop downs, I just don't get why, is it possible the <SPAN> is some how preventing this?

I basically have a drop down that you select that determines what gets populated in the "city" drop down:
Expand|Select|Wrap|Line Numbers
  1. <code>
  2.  
  3.  <select size="1" name="itemType1" onChange="getCity('material1','findcity.php?itemType='+this.value)"><option selected 
  4.         value=""></option> <option value="Material">Material</option><option value="PH1">PH1</option> <option 
  5.         value=PH2>PH2</option> <option value="PH3">PH3</option> <option 
  6.         value=PH4>PH4</option> &lt;\SELECT&gt;</select>
  7. </code>
This is the function for it:
Expand|Select|Wrap|Line Numbers
  1. <code>
  2.     function getCity($elementID,strURL) {        
  3.  
  4.         var req = getXMLHTTP();
  5.  
  6.         if (req) {
  7.  
  8.             req.onreadystatechange = function() {
  9.                 if (req.readyState == 4) {
  10.                     // only if "OK"
  11.                     if (req.status == 200) {                        
  12.                         document.getElementById($elementID).innerHTML=req.responseText;                        
  13.                     } else {
  14.                         alert("There was a problem while using XMLHTTP:\n" + req.statusText);
  15.                     }
  16.                 }                
  17.             }            
  18.             req.open("GET", strURL, true);
  19.             req.send(null);
  20.         }
  21.  
  22.     }
  23. </code>
which then populates the "material1" <span>

Like I said, I've been stumbling through all of this, I got it all working, except for getting the value from the city drop down (it does populate).

Expand|Select|Wrap|Line Numbers
  1. <code>
  2.  <span id="material1">
  3. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city1" id="city1">
  4.  </select>    </span>
  5. </code>
Aug 17 '10 #9
I wrote a whole long response, and it stated it had to be approved before it was shown, that was yesterday...what gives?
Aug 18 '10 #10
Dormilich
8,658 Expert Mod 8TB
that’s this forum’s spam filter, it sometimes catches even post, that are not spam.

back to the topic, when you load your page for the first time, there are no POST data available, since you didn’t submit the form. you need to check your form data before use as mentioned in post #8.
Aug 20 '10 #11
Thanks for the reply, and the explanation of the SPAM filter.

I think I understand post 8, setting it to a default value if it isn't already set, I just don't understand why mine is not getting set.

I set the drop down to a value, and then hit submit to submit the form, all of my other POST variables are set, but this specific one is not, it's also the only one using AJAX...I've spent endless time staring at the code, it's got to be something I don't know about.
Aug 20 '10 #12
JKing
1,206 Expert 1GB
What does the response text look like?
Aug 20 '10 #13
Notice: Undefined index: city1 in C:\wamp\www\TS\upload.php on line 8

So city1 is a drop down in my main php page, then when the form is submitted (to upload.php), I try to set a variable to the $_POST["city"] value, but it's not setting (for some reason)
Aug 20 '10 #14
JKing
1,206 Expert 1GB
Sorry I should have been more specific.

Can you copy and paste the html that is produced by the ajax call to populate the drop down.
Aug 20 '10 #15
Ahhh, that's a good idea actually, and I don't see the drop-down being populated in HTML, so I guess that is my problem :(

Expand|Select|Wrap|Line Numbers
  1.  <select size="1" name="itemType1" onChange="getCity('material1','findcity.php?itemType='+this.value)"><option selected 
  2.         value=""></option> <option value="M">Material</option><option value="1">PH1</option> <option 
  3.         value=2>PH2</option> <option value="3">PH3</option> <option 
  4.         value=4>PH4</option> &lt;\SELECT&gt;</select>           
  5.  
ItemType1 is selected, which then calls a function which populates the drop down, city1.

Expand|Select|Wrap|Line Numbers
  1. <span id="material1">
  2. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city1" id="city1">
  3.  </select>    </span>
  4.  
I can see all of the values in the drop down, but it doesn't look like the values are anywhere in the HTML...now I am really confused.
Aug 20 '10 #16
JKing
1,206 Expert 1GB
That's because the ajax adds in the text after the html has been posted to the browser.

You will need to grab the HTML from the file the AJAX is calling. Have a look in there and make sure it is formatted properly with values for each option in the select.

Alternatively you could use Firebug which is a browser addon to inspect the HTML after it has been changed by the javascript.
Aug 20 '10 #17
THANK YOU, that makes sense to me, I'll take a look and report back (possibly not until monday).
Aug 20 '10 #18
Ok, I've found the problem, and spend the past couple hours trying to solve it, but I'm just not getting it. If anyone could give me a pointer that would be awesome

I have my first drop down, which when selected runs the getcity function:

Expand|Select|Wrap|Line Numbers
  1. <select size="1" name="itemType1" onChange="getCity('material1','findcity.php?matNum=citys1&itemType='+this.value)"><option selected 
  2.         value=""></option> <option value="M">Material</option><option value="1">PH1</option> <option 
  3.         value=2>PH2</option> <option value="3">PH3</option> <option 
  4.         value=4>PH4</option> &lt;\SELECT&gt;</select>           
  5.        <span id="material1">
  6. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name="city1" id="city1">
  7.  </select>    </span>           
  8.  
The getcity function:

Expand|Select|Wrap|Line Numbers
  1.     function getCity($elementID,strURL) {        
  2.  
  3.         var req = getXMLHTTP();
  4.  
  5.         if (req) {
  6.  
  7.             req.onreadystatechange = function() {
  8.                 if (req.readyState == 4) {
  9.                     // only if "OK"
  10.                     if (req.status == 200) {                        
  11.                         document.getElementById($elementID).innerHTML=req.responseText;                        
  12.                     } else {
  13.                         alert("There was a problem while using XMLHTTP:\n" + req.statusText);
  14.                     }
  15.                 }                
  16.             }            
  17.             req.open("GET", strURL, true);
  18.             req.send(null);
  19.         }
  20.  
And the page that it calls, this has the code that replaces the drop down I have, with the dynamic content, the only problem is, I have 10 of these drop downs, so this function is called each time one is selected, I'm not sure how to have the NAME of the drop down dynamic, for example, the first drop down be called city1, the next city2, etc.. I can manually set the name to be city1, and the first drop down will work great, but none of the others will.

Specifically this line in the below code:

Expand|Select|Wrap|Line Numbers
  1. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name=<?php"'.$matNum1.'"?>>
  2.  
You can see I have the name=$matNum1 .. hoping it would pull the "citys1" name I passed it from the previous page, but that's not working, I just need to get this name being dynamic so each time I call this function, it uses the same name as the drop down it is replacing.

The full findcity.php code:

Expand|Select|Wrap|Line Numbers
  1. <?php $itemType=$_GET['itemType'];
  2. $matNum1=$_GET['matNum'];
  3.  
  4. function sqlSelect($daisySelect)
  5. {
  6.   //connect to a DSN, "daisy" 
  7. $conn = odbc_connect('daisy','chrisbwamp',''); 
  8. if ($conn) 
  9. { 
  10.   //The SQL statement that will query the database 
  11.   $query = $daisySelect; 
  12.  
  13.   //Perform the query 
  14.   $result=odbc_exec($conn, $query); 
  15.  
  16.   //Convert results to an array
  17.   while(odbc_fetch_row($result))
  18.   { 
  19.      for($i=1;$i<=odbc_num_fields($result);$i++)  
  20.           {
  21.              $selectArray[]=odbc_result($result,$i);
  22.           }
  23.   } 
  24. return $selectArray;
  25. }
  26.  else echo "ODBC not connected, please contact ITHelpdesk@pintys.com, reference Chris Beach";  
  27. }
  28.  
  29. if ( $itemType == "M" ) 
  30.     $arrProductNum=sqlSelect("SELECT Material_ID + ' - ' + DESCRIPTION AS Expr1 FROM VW_TradeSpend_Material ORDER BY Material_ID ASC");
  31. elseif( $itemType == "1" )
  32.       $arrProductNum=sqlSelect("SELECT DISTINCT LEVEL1_DESC FROM pintys.PROD_HIERARCHY");
  33. elseif( $itemType == "2" )
  34.       $arrProductNum=sqlSelect("SELECT DISTINCT LEVEL2_DESC FROM pintys.PROD_HIERARCHY");
  35. elseif( $itemType == "3" )
  36.       $arrProductNum=sqlSelect("SELECT DISTINCT LEVEL3_DESC FROM pintys.PROD_HIERARCHY");
  37. elseif( $itemType == "4" )
  38.       $arrProductNum=sqlSelect("SELECT DISTINCT LEVEL4_DESC FROM pintys.PROD_HIERARCHY");
  39. ?>
  40.  
  41. <select style="width: 158px;" onclick="this.style.width='340px';this.size='10'" onmouseout="this.style.width='158px';this.size=''" class="widthed" name=<?php"'.$matNum1.'"?>>
  42. <option></option>
  43.  
  44. <?php
  45. foreach($arrProductNum as $products) { 
  46. echo'<option value="'.$products.'">'.ltrim($products,"0").'</option>'; } 
  47.       echo "</select>"; 
  48. ?>
  49.  
I've attempted to send the word "citys1" in my drop down in my own form, and have the "findcity.php" pick it up as matNum1, and use it as the "name" so it could be dynamic, but it's not working :(
Aug 23 '10 #19
Got it! :)

I used an HTML array (I didn't know they existed), this solved that problem.

Thanks for all the help.
Aug 23 '10 #20
Dormilich
8,658 Expert Mod 8TB
what is an HTML array?
Aug 23 '10 #21
I take it by your answer, no such thing exists :p

I'm new to all of this, so not sure the proper name, but I basically set the name of my drop down box as:

Expand|Select|Wrap|Line Numbers
  1. name="citysTest[]"
  2.  
Which seems to act as an array, and increment each time the ajax is called, so then when uploading all of the values through PHP, I'm able to reference
Expand|Select|Wrap|Line Numbers
  1. $citysTesting = $_POST['citysTest'];
  2.  
And then loop through uploading each value of the drop down boxes
Aug 23 '10 #22
Dormilich
8,658 Expert Mod 8TB
I'm new to all of this, so not sure the proper name, but I basically set the name of my drop down box as:

Expand|Select|Wrap|Line Numbers
  1. name="citysTest[]"
  2.  
yepp, that’s the way to tell PHP that it should put these elements in an array.
Aug 24 '10 #23

Sign in to post your reply or Sign up for a free account.

Similar topics

1
Error message- Notice: Undefined index:
by: Hal Halloway | last post by:
How do I fix this error message below? Thanks. Notice: Undefined index: key_word in C:\Program Files\Apache Group\Apache2\htdocs\search010.php on line 55 .... if( $_GET ) { // line 55 //...
PHP
6
Notice: Undefined index: Error
by: jsgoodrich | last post by:
I am looking for some help if anyone can lend a hand. I have a simple php website that displays a table from my mysql database. To prep for my MCSE I moved my home server to Windows 2003...
PHP
3
Notice: Undefined index:
by: number1yan | last post by:
Can anyone help me, i am creating a website and am using a php script that recomends the website to other people. I keep getting the same error and can not work out why. The error is: Notice:...
PHP
3
Error: Notice: Undefined index: channels in /home/forcefed/public_html/index.php on
by: sickboy | last post by:
$channels=$_GET; if (empty($channels)) { $channels='blank'; } changechannels($channels); $theatre=$_GET; if (empty($theatre)) { $theatre='splash'; } changetheatre($theatre); $info=$_GET; if...
PHP
1
Notice: Undefined Index on remote server but not in local testing.
by: francsutherland | last post by:
Notice: Undefined index: send in D:\Domains\workingdata.co.uk\wwwroot\contact_text.php on line 7 Hi, I've started getting this error in the contact page form of my website. The web hosting...
PHP
10
Notice: Undefined index...
by: FutureShock | last post by:
I have since recently turned up my error reporting on a production site to E_ALL to ensure I am using 'best practices' when writing out code. So far it has helped me discipline myself with...
PHP
11
Notice: Undefined index message
by: stealthmode666 | last post by:
New to .php so need script help. I want to know how to stop this being displayed when I click submit. Notice: Undefined index: homeowner in E:\domains\r\...\user\htdocs\...\form.php on line 166 ...
PHP
4
Notice: Undefined index: rand in .....
by: complearn | last post by:
Do you know why I got these errors for status_bar.php in some webhost, but work perfectly on other webhost? Whats wrong? here are the codes from line 18, our webhost is running php5. ...
PHP
1
Notice: undefined index: dec in...
by: duffy832 | last post by:
I am making changes to a php framework I downloaded and am new to PHP. I have this error: Notice: Undefined index: dec in D:\Hosting\4156690\html\idingo\modules\groups\group_sort.php on line 49...
PHP
3
Notice: Undefined index:..
by: razvanel442 | last post by:
Hi all i am new here! I take a look on forum but i don't found a the answer for my problem ok this is my problem: Line47:$user = $_GET; Line48:$pass = $_GET; Line49:$char = $_GET;
PHP
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!