[SOLVED] form will not submit

trampolinejoe · November 26, 2008

Hello to all you wonderful people!

I have a website back end and I created a page which lets people edit orders that have been placed. great..

actually not really, because it will not submit!!!

For some reason nothing happens when i click on submit, can anybody tell me what i did wrong?

(btw, the form fills itself depending on whos profile you are editing.)

<html>
<?php 
include("head.php");
include("dbcon.php"); 

$connote =  $_GET["connote"];
$connote = "'$connote'";
$connoteResult = mysql_query("SELECT * FROM Orders WHERE connote = " . $connote);

while($row = mysql_fetch_array($connoteResult))
  {

		$email= $row['email'];
		$zip = $row['zip'];
		$warranty = $row['warrantyLength'];
		$orderNotes = $row['orderNotes'];
		$later = $row['later'];// determines a later date
		$laterDate = $row['laterDate'];
		$connote = $row['connote'];
		$status = $row['status'];
		$name = $row['firstName'];
		$held = $row['held'];
		$deliveryNotes = $row['tntNote'];
		$paymentMethod = $row['paymentMethod'];
		$customerID = $row['customerID'];
		$date = $row['date'];
		$status = $row['status'];
		 }	



$customerIDfinder = mysql_query("SELECT customerID FROM Orders WHERE connote =" . $customerID );

while($row = mysql_fetch_array($customerIDfinder))
	  {	
			$customerID = $row['customerID'];
        	}


//get the customer id from the other query 
$customerResult = mysql_query("SELECT * FROM CustomerTable WHERE customerID =" . $customerID );

while($row = mysql_fetch_array($customerResult))
  {	 
	    $firstName = $row['firstName'];
		$lastName = $row['lastName'];
		$aCode = $row['aCode'];
		$phoneNumber = $row['phoneNumber'];
		$mobNumber = $row['mobNumber'];
		$email = $row['email'];
		$customerNotes = $row['customerNotes'];
		$customerAddress = $row['customerAddress'];
		$suburb = $row['suburb'];
		$state = $row['state'];
		$zip = $row['zip'];
		$street = $row['street'];

     }


	// set the form to refill the details in by itself

	 $QLD = $row['state'] == "QLD" ? ' selected="selected"' : '';
	 $NSW = $row['state'] == "NSW" ? ' selected="selected"' : '';
	 $WA = $row['state'] == "WA" ? ' selected="selected"' : '';
	 $SA = $row['state'] == "SA" ? ' selected="selected"' : '';
	 $TAS = $row['state'] == "TAS" ? ' selected="selected"' : '';
	 $NT = $row['state'] == "NT" ? ' selected="selected"' : '';
	 $VIC = $row['state'] == "VIC" ? ' selected="selected"' : ''; 
	 $ACT = $row['state'] == "ACT" ? ' selected="selected"' : ''; 
	 $state = $row['state'];

	$yes = $row['later'] == "yes" ? ' selected="selected"' : ''; 
	$no = $row['later'] == "no" ? ' selected="selected"' : ''; 
	//$later = $row['later'];

	// Add the status change option in the backend version
  $yesInstall = $install == "yes" ? 'selected="selected"' : ''; 
  $noInstall = $install == "no" ? 'selected="selected"' : ''; 




	  ?>


<body>

<div id="wrapper">


<?php include("nav.php"); ?> <!-- includes the nav bar -->


		  
	<div id="content">

		<div id="orders">
		<br>
<br>

<form name="form1" method="post" action="updateEngine.php?connote=<?php echo "$connote" ?>" >

Edit the Order below, then submit.
<br>
<br>
<fieldset>
<legend><strong>Order Details</strong></legend>
<table width="900">

<td width="200" class="display"><strong>Products Ordered</strong></td>
<td width="350">
<?php 

function getProduct($id){

$productFinder = mysql_query("SELECT name FROM Products WHERE ID =" . $id );

while($row = mysql_fetch_array($productFinder))
	  {	
			$product = $row['name'];
        	}

     return $product;
}

$order = mysql_query("SELECT * FROM OrderProducts WHERE OrderId =" . "'$connote'" );

$products = array();
   while($row = mysql_fetch_array($order))
        {   
            array_push($products,$row['ProductId']); //place product ids in array
                 
        }
//output array
$i = 0;
while($i < sizeof($products)){
echo getProduct($products[$i]);
echo " \n";
$i++;
}


?><br>
<br>

</td>

</td>

<tr>
<td width="200"><strong>Product</strong> </td>
<td width="350">
<?php

echo" <select name='product[]' id='product' size='5' tabindex='1' class='validate required product productMsg' multiple>";                      //start the select box 

$results= mysql_query("SELECT ID, name FROM Products ORDER BY ID asc",$connection); 
$id = "ID";
$idname = "Name"; 
echo mysql_error(); 

	if (mysql_Numrows($results)>0)                            //if there are records in the fields
	{ 
	  $numrows=mysql_NumRows($results);                       //count them
	  $x=0; 
	  while ($x<$numrows){   //loop through the records
		$theId=mysql_result($results,$x,$id);                 //place each record in the variable everytime we loop
		$theName=mysql_result($results,$x,$idname);
		echo "<option value=\"$theId\">$theName</option>\n";  //and place it in the select
		$x++;
	  }
	}
echo "</select>";  //close the select

//DONE



?>
</td>
<td  id ="productMsg"  class="display">
</td>

<td width="200" class="display"><strong>Warranty:</strong></td>
<td width="350">
  <select name="warranty">
	<option value="1">1</option>
	<option value="3">3</option>
	</select></td>
<td></td>
</td>

</tr>

      		<tr>
          		<td width="130"><strong>Order Notes:</strong></td>
          		<td><textarea name="orderNotes" cols="40" rows="4"><?php echo"$orderNotes" ?></textarea></td>
      	    </tr>

		<tr>
          		<td width="190"><strong>Send at later date:</strong></td>
          		<td><select name="later" id="later">
			<option value="no" <?=$no ?>>no</option>
			<option value="yes" <?=$no ?>>yes</option>
			</select> (If so please insert date)
			</td>

		</tr>

		<tr>
		<td width="190"><strong>Date:</strong></td>
			<td><input type="text" name="laterDate" value="<?php echo"$laterDate" ?>" size="10"></td>
      	    </tr>
  
</table>
</fieldset>

	<br>
	<br>



        <fieldset>
        <legend><strong>Customer Information</strong></legend>
        <table width="900">
    		<tr>
        		<td width="200"><strong>First Name:</strong> </td>
        		<td width="350"><input type="text" name="firstName" value="<?php echo"$firstName" ?>" size="40" tabindex="2" id="firstName" class="validate required none firstNameMsg"/></td>
        		<td  id ="firstNameMsg"  class="display"> </td>
    	    </tr>

    	    <tr>
        		<td width="130"><strong>Last Name: </strong></td>
        		<td width="350"><input type="text" name="lastName" value="<?php echo"$lastName" ?>" size="40" tabindex="3" id="lastName" class="validate required none lastNameMsg"/></td>
        		<td id ="lastNameMsg"  class="display"> </td>
    	    </tr>
    	    
    	    <tr>
        		<td width="130"><strong>Phone Number:</strong> </td>
        		<td width="3">
        		    <input type="text" name="phoneNumber" value="<?php echo"$phoneNumber" ?>" size="15" tabindex="5" id="phoneNumber" class="validate required number phoneNumberMsg"/>
        		</td>
        		<td id ="aCodeMsg"  class="display"> </td>
        		<td id ="phoneNumberMsg"  class="display"> </td>
    	    </tr>
    	    
    	    <tr>
        		<td width="130"><strong>Mobile Number:</strong> </td>
        		<td width="20"><input type="text" name="mobNumber" value="<?php echo"$mobNumber" ?>" size="20" tabindex="6" id="mobNumber" class="validate notrequired number mobileNumberMsg"/></td>
        		<td id ="mobileNumberMsg"  class="display"></td>
    	    </tr>
    	    
    	    <tr>
        		<td><strong>Email:</strong> </td>
        		<td><input type="text" name="email" value="<?php echo"$email" ?>" tabindex="7"  id="email" class="validate required email emailmsg" /></td>
    		    <td id="emailmsg" class="display"> </td>
        </tr>
        
        <tr>
           <td><strong>Notes about the customer:</strong></td>
           <td><textarea name="customerNotes" tabindex="8" cols="40" rows="4"><?php echo"$customerNotes" ?></textarea></td>
        </tr>

    	</table>
    	</fieldset>
	<br>
	<br>
    	<fieldset>
        <legend><strong>Customer Address</strong></legend>
        <table width="900">
    	    <tr>
        		<td width="130"><strong>Street</strong></td>
        		<td width="130"><input type="text" value="<?php echo"$street" ?>" name="street" size="50" tabindex="9" id="street" class="validate required none streetMsg"/></td>
        		<td class="display"> </td>
    	    </tr>
    
    	       <tr>
        		<td width="130"><strong>Suburb</strong></td>
        		<td width="130"><input type="text" value="<?php echo"$suburb" ?>" name="street" size="50" tabindex="9" id="street" class="validate required none streetMsg"/></td>
        		<td class="display"> </td>
    	    </tr>

    	    <tr>
        		<td width="130"><strong>State: </strong></td>
        		<td width="130">
			  <select name="state">
				  <option value="ACT"<?=$ACT ?>>ACT</option>
				  <option value="QLD"<?=$QLD ?>>QLD</option>
				  <option value="NSW"<?=$NSW ?>>NSW</option>
				  <option value="VIC"<?=$VIC ?>>VIC</option>
				  <option value="SA"<?=$SA ?>>SA</option>
				  <option value="WA"<?=$WA ?>>WA</option>
				  <option value="TAS"<?=$TAS ?>>TAS</option>
				  <option value="NT"<?=$NT ?>>NT</option>
			  </select>
                </td>
        		<td id ="stateMsg"></td>
        	</tr>

      		<tr>
          		<td width="130"><strong>Post Code:</strong> </td>
          		<td width="130"><input type="text" name="zip" value="<?php echo"$zip" ?>" size="4" maxlength="4" tabindex="12" id="zip" class="validate required zip zipMsg"/></td>
          		<td id ="zipMsg"  class="display"> </td>
  	        </tr>

    	</table>
    	</fieldset>
    	
    	<br><br>
    	<fieldset>
        <legend><strong>Delivery Notes</strong></legend>
        <table width="900">

        <tr>
           <td>Delivery notes</td>
           <td><textarea name="tntNote" wrap=physical cols=28 rows=4 onKeyDown="textCounter(this.form.tntNote,this.form.remLen,80);"
	              onKeyUp="textCounter(this.form.tntNote,this.form.remLen,80);"><?php echo"$deliveryNotes" ?></textarea></td>
	       <td><input readonly type=text name=remLen size=3 maxlength=3 value="49"> characters left</font></td>
	    </tr>


        <tr>
           <td>Install:</td>
           <td>
			<select name="install">
			<option value="no" <?=$noInstall ?>>no</option>
			<option value="yes" <?=$yesInstall ?>>yes</option>
			</select>
	</td>
	      
	    </tr>

        </table>
        </fieldset>
	<br>
<br>


<fieldset>
        <legend><strong>Payment and Billing</strong></strong></legend>
        <table width="900">

        <tr>
           <td><strong>Payment Type:</strong></td>
           <td  width="130"> 
	  <select name="paymentMethod">
	  <option value="cc">Credit Card Phone</option> 
	  <option value="ccs">Credit Card Store</option> 
	  <option value="cco">Credit Card Online</option>
	  <option value="dd">Direct Deposit</option>
	  <option value="cod">Cash on Delivery</option> 
	  <option value="cs">Cash in Store</option> 
	  <option value="ch">Cheque</option> 
	  </select>	
	  
	 </td>
	       <td  width="130"></td>
	    </tr>

       <tr>
           <td><strong>Status:</strong></td>
           <td  width="130"><?php echo"$status" ?></td>
	       <td  width="130"></td>
	    </tr>

        </table>

        </fieldset>
	<br> <input name="Submit" type="button" value="Submit"></form>


	  <br><br><br>


       </div>
   </div>
    </div>
    </body>
</html>

trampolinejoe · November 26, 2008

hey guys, i am such a fool, i just noticed

<input name="Submit" type="submit" value="Submit">

so sorry to waste your time!

Sign In

[SOLVED] form will not submit

Recommended Posts

trampolinejoe

Link to comment

Share on other sites

trampolinejoe

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information