title: universal login name
body: <p>Is there a way to make the username part work for both upper and lower case, for example if my username were robert if you entered Robert it would work as well? Attached is a copy of my login script. </p>
  
  <pre><code>&lt;?php
  
  session_start();
  
  $username = $_POST['username'];
  $password = $_POST['password'];
  
  if ($username&amp;&amp;$password)
  {
  
  $connect = mysql_connect("localhost","*i*****5_******","*******") or die ("Couldn't Connect"); //host,username,password
  mysql_select_db("virtua15_gateway") or die ("Could not find database");
  
  $query = mysql_query("SELECT * FROM Users WHERE username='$username'");
  $numrows = mysql_num_rows($query);
  if ($numrows!=0)
  {
      while ($row = mysql_fetch_assoc($query))
      {
              $dbusername = $row['username'];
              $dbpassword = $row['password'];
      }
      if ($username==$dbusername&amp;&amp;md5($password)==$dbpassword)
      {
       header( 'Location: index2.php' );
       $_SESSION['username']=$dbusername;
      }
      else
          echo "incorrect username and password";
  }
     else
       die ("This user does not exist");
  
  }
  else
      die("Please enter a username and a password")
  
  
  ?&gt;
  </code></pre>