title: Mysql Multiple table select with condition
body: <p>I have a noob question but rather a troublesome one for me. I am using SELECT on three tables the middle one of which is realtional (Holds relations - ID of user against ID of Place), the first is a table of users, the last of places. I have written this perfectly woking query </p>
  
  <pre><code>$query = "SELECT users.Username,usrxplc.User,places.Name
            FROM users,usrxplc,places
            WHERE usrxplc.Place=places.ID AND usrxplc.User=users.ID"
  </code></pre>
  
  <p>That spits out all places associated with all users. Fine, but I would like to limit it only to a certain user. Seems simple, but I am stuck.</p>