CodeIgniter Forums

Full Version: can we use two 'AND' operator in mysql......................
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]noname525[/eluser]
vv

El Forum

[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

El Forum

[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 Wink