title: Retrieve Order Status from MYSQL database based on value entered
body: <p>I have created a MySQL database, in which one of my tables is "ServiceOrder" The ServiceOrder table will hold data of order than have been placed by customers and the status of these order, e.g. To be started, Started, Quality Assurance, Finished.</p>
  
  <p>So, I have a website, on which I have a form (see below). In the form I want to allow people to enter their order ID's to retrieve the status of their order. Note: the "ServiceOrder" database include the field, orderID and Status (amongst other things which aren't relevant for this).</p>
  
  <p>Here is my HTML form:</p>
  
  <pre><code>&lt;form id="form1" name="form1" method="post" action=""&gt;
  Insert Order Number Here
      &lt;input name="woodingdeantracking" type="text" id="woodingdeantracking" size="40" /&gt;
      &lt;input type="submit" name="Track Order" id="Track Order" value="Track Order" /&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>What I ideally want it to do for now is when a customer enteres an OrderID that exists it will send them to once page, however if the orderID doesnt't exist they get sent to a different poage.</p>
  
  <p>I hope I have been clear. If any other information is required, please let me know, I am very new to this!</p>
  
  <p>Thanks in advance,
  Nav</p>
  
  <p>P.S I am open to using Javascript if it is easier for what I am trying to acheieve for the demo, in essence if "ABC" is enetered return sucess page if anything else is enetred return a failure page.</p>