title: PHP and MySQL select
body: <p>Okay so I'm making php that will pull every entry from a data base that matches the name you put in a textbox. so here is a image of the database
  <a href="http://i.stack.imgur.com/LvmrM.png" rel="nofollow">http://i.stack.imgur.com/LvmrM.png</a> &lt; screen shot of database</p>
  
  <p>So if i where to put "DigitalNuke" in the textbox and hit the submit button I want only the rows that have "DigitalNuke" as the value in the second column "referrer"</p>
  
  <pre><code>&lt;form ACTION="" METHOD=post&gt;
  &lt;div class="input-append"&gt;
    &lt;input class="span2" id="youruser" type="text" name="youruser" placeholder="Your Username"&gt;
    &lt;button class="btn btn-success" type="submit"&gt;Retrive&lt;/button&gt;
  &lt;/div&gt;
  &lt;/form&gt;
  &lt;?php
     require_once 'connect.php';
     $name = isset($_POST['youruser']);
     $conn=  mysqli_connect ($dbhost,$dbuser,$dbpass,$dbname)or die(mysqli_error());
     $query1 = "SELECT 'id', 'referrer', 'username', 'brigade', 'faction', 'activity' FROM refmems WHERE referrer='$name";
     $result = mysqli_query($conn, $query1)
        or die('Error querying the database: ');
    echo '&lt;table class="table table-bordered"&gt;';
    echo '&lt;caption&gt;Your Referred Members&lt;/caption&gt;' . '&lt;thead&gt;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;' . '&lt;th&gt;Username&lt;/th&gt;' . '&lt;th&gt;Brigade&lt;/th&gt;' . '&lt;th&gt;Faction&lt;/th&gt;' . '&lt;th&gt;Activity&lt;/th&gt;' . '&lt;/tr&gt;&lt;/thead&gt;';
        while ($row = mysqli_fetch_array($result)) {
    echo "&lt;tr class='success'&gt;&lt;td&gt;" . $row['id'] . "&lt;/td&gt;&lt;td&gt;" . $row['username'] . "&lt;/td&gt;&lt;td&gt;" . $row['brigade'] . "&lt;/td&gt;&lt;td&gt;" . $row['faction'] . "&lt;/td&gt;&lt;td&gt;" . $row['activity'] ."&lt;/td&gt;&lt;/tr&gt;";     
  }
  ?&gt;
  </code></pre>
  
  <p>So as of now it doesn't do anything when I hit the submit button. Well it kind of works, except for instead of pulling the data from the table, it just puts id, username, brigade, faction, activity in each row of the generated table. 
   <a href="http://i.stack.imgur.com/XF71h.png" rel="nofollow">http://i.stack.imgur.com/XF71h.png</a> &lt; screen shot</p>
  
  <p>Any help would be appreciated, if you need anything else let me know and i'll post it.</p>