title: How do i concat two columns in Database and then select all values against it
body: <p>This is my code but on clicking <code>Login</code> button it shows error like this </p>
  
  <blockquote>
    <p>Connection MaintainedError: select * from signup where username='abc' and password='1234'</p>
  </blockquote>
  
  <pre><code>if(isset($_POST['log'])){
  $uname = $_POST['uname'];
  $pass = $_POST['pass'];
  $dbm = new MySQLi("localhost","root","","lsa");
      if($dbm-&gt;connect_errno &gt; 0){
          die("Error".$dbm-&gt;connect_error);
          }
          var_dump($dbm);
          echo "Connection Maintained";
          $up = "update signup set username = concat(First_name, ' ' , Last_Name)";
          $qm="select * from signup where username='$uname' and password='$pass'";
          if ($dbm-&gt;query($qm) === TRUE) {
              echo "New record created successfully";
              } else {
                  echo "Error: " . $qm . "&lt;br&gt;" . $dbm-&gt;error;
                  }   
  
  $dbm-&gt;close();
  </code></pre>
  
  <blockquote>
    <p>here is my login form code*</p>
  </blockquote>
  
  <pre><code>&lt;form action="Admin.php" method="post"&gt;
  &lt;fieldset style="text-align:center; margin-left:2%; margin-top:9%; margin-right:10%"&gt;
  &lt;legend style="text-align:start; font-family:'Palatino Linotype', 'Book Antiqua', Palatino, serif; color:#FFF; font-size:36px"&gt;Login
  &lt;/legend&gt;
  &lt;br /&gt;&lt;input type="text" placeholder=" Username" name="uname" title="Your First Name" style="height:25px; width:200px" required="required"  /&gt;&lt;br /&gt;&lt;br /&gt;
  &lt;input type="password" placeholder=" Password" name="pass" style="height:25px; width:200px" required="required" /&gt;&lt;br /&gt;&lt;br /&gt;
  &lt;input type="submit" value="Login" name="log" style=" border-radius:50%; border-color:#FFF; width:100px" /&gt;
  &lt;br /&gt;
  &lt;br /&gt;
  &lt;/fieldset&gt;
  &lt;/form&gt;
  </code></pre>