title: SQL giving me lines that doesn't exist?
body: <p>While using this:</p>
  <pre><code>SELECT borrowbook.studentusername, borrowbook.schoolbookid,borrowbook.date,borrowbook.deadline, book.title, student.email, student.fname, student.lname
  FROM borrowbook, book, student
  </code></pre>
  <p>I get many lines, but in my database I just have four lines in the borrowbook table, and while using this, I get some &quot;lines&quot; that doesn't exist. (Note: this works through php on a website, I cannot seem to make this work in mysql so I think I have done something)</p>
  <p>Like that a person that had borrowed one book (line 1 in my list of borrowed books) suddenly has borrowed ten different books that I have not registered anyone to borrow. With date as to when it was loaned, and deadline just taken from one of the four lines I have registered.</p>
  <p>Even the same person that is registered to borrow one book, suddenly shows up as if they borrowed it four times with different dates. Dates and deadline are taken from &quot;borrowbook&quot; while different names of students are taken from another table, since they have never been used in the &quot;borrowbook&quot; line.</p>
  <p>I have tried this now in different ways and with different content and different tables, but still get many &quot;made up&quot; lines of loans that is not registered.</p>
  <p>I know very little, but I am grateful for all help I can get. Articles help as well.</p>