title: Why do i get this result?
body: <pre><code>SELECT * 
  FROM afspraken
  WHERE user_id =  '2'
  AND datum &gt;  '2012-06-05'
  OR (
  user_id =  '2'
  AND datum =  '2012-06-05'
  AND begintijd &gt;=  '22:47'
  )
  ORDER BY datum DESC , begintijd ASC 
  </code></pre>
  
  <p>This above is my query.. And while i should get zero result i still get one which is:</p>
  
  <pre><code>id  user_id     datum      begintijd    opmerking
  114 2         2012-06-05    9:30        Deze afspraak is online gemaakt.
  </code></pre>
  
  <p>Now if i have this correctly, this query has 2 options to give results.. which is:
  The user_id must be the same AND the date has to be higher then 2012-06-05.. Since its the same date this won't give the result.. </p>
  
  <p>Now the second option which is when the user_id is the same, the date is the same and when the beginningtime is the same or higher.. Now the time in the query shown is 22:47.. The time in the database is 9:30 morning.. How is 9:30 morning higher or equal to 22:47??</p>
  
  <pre><code>    id  int(10)                             
      user_id int(10) 
      datum   date    
      begintijd   varchar(5)
      opmerking   varchar(8000)
      reminder    int(10)
  </code></pre>