title: Calculate days between two or three days in one table
body: <p>I have a table named transaction_detail which contains id_transd, id_trans, id_cust and inputtime.</p>
  
  <pre><code>  id_transd | id_trans | id_cust | inputtime           |
    1         | 1        | 1       | 2013-04-15 16:55:58 | 
    2         | 1        | 1       | 2013-05-15 16:55:58 | 
    3         | 1        | 1       | 2013-06-15 16:55:58 |
    4         | 2        | 2       | 2013-06-15 16:55:58 | 
    ...
  </code></pre>
  
  <p>I want to get the amount of the inputtime which have the same id_cust and id_trans.<br> For example : when admin wants to count how long the job done on one costumer then admin need to click on the name of the customer and system will calculate the date.</p>
  
  <pre><code> |No.| Name     | Process     | Time                |
   |1. | D-net    | by sales    | 2013-04-15 16:55:58 |
   |   |          | by sadmin   | 2013-05-15 16:55:58 |
   |   |          | by technic  | 2013-06-15 16:55:58 |
  </code></pre>
  
  <p>I've tried this code</p>
  
  <pre><code>SELECT t.* datediff(DAY, t.inputtime, nextdate) AS Days_Between
  FROM
    (SELECT t.*,
      (SELECT min(inputtime)
        FROM transaksi_detail t2
        WHERE t.id_cust = t2.id_cust
          AND t.id_trans = t2.id_trans
          AND t.inputtime &lt; t2.inputtime) AS nextdate
     FROM transaction_detail t)t
  </code></pre>
  
  <p>But won't work, It says :</p>
  
  <pre><code>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in F:\htdocs\indosat2\hitung_tanggal2.php on line 20
  </code></pre>