title: if(isset($_GET['Submit']))... help
body: <p>good am.
  i have a query that needs a value upon submission.. here it is</p>
  
  <pre><code>&lt;?php
  $conn = mysql_connect("localhost","root","");
  
  mysql_select_db('irm',$conn);
  
  if(isset($_GET['Submit'])){
  $customer_date = $_GET['customer_date'];
  }
  ?&gt;
  &lt;?php
  
  $tryshow =" SELECT c.customer_date, c.lastname, c.firstname,
     s.room_number, s.date_in, s.date_out
  FROM customers c
      INNER JOIN services s
          ON c.customer_date = s.date_in
   WHERE c.customer_date = '$customer_date'";
  
  $result = @mysql_query($tryshow,$conn)
              or die(mysql_error());
  
  if (mysql_num_rows($result) == 0) {
  echo "No rows found, nothing to print...";
  }
  while($row=mysql_fetch_assoc($result)){ 
  ?&gt;
  </code></pre>
  
  <p>i think my problem is that even i submit a date the $customer_date doenst hold any value and thus leading to my no rows found echo...</p>
  
  <p>need some of your advice and thanks in advance hope you can help me soon
  -renz</p>