can we use two 'AND' operator in mysql......................

[eluser]noname525[/eluser]
vv

[eluser]bgreene[/eluser]
well the query condition is valid ie "where a = b and between x and y" is ok so the fault lies elsewhere

[eluser]Aken[/eluser]
Try giving your SUM() function an alias, so it can actually return a column name.

Code:

SELECT SUM(charge) AS total_charges

Also please post in the appropriate forum sections in the future