Lo he escrito asi ahora y tampoco me funciona:
Código PHP:
Ver originalmysql_query("SELECT usuari_compres, article, quantitat, preu, pagament, datainicial AS datainicial2, DATEDIFF(CURDATE( ), datainicial) AS datafinal2 FROM compres WHERE pagament = 'si' And datafinal2 BETWEEN 1 and 30");