I'm surprised it ever worked, if it was exactly as you gave us. You have
SUM(quantity)*100/ AS percentage
It looks like you intended to divide SUM(quantity)*100 by something, but
there's nothing there to divide by.
Michael
Aaron Wolski wrote:
Hi all,
Have a query that used to work on one serve
Hi all,
Have a query that used to work on one server but then MYSQL version was
upgraded and now it no longer works. Here's the query:
SELECT *, SUM(quantity)*100/ AS percentage FROM CartTable WHERE company
='1' AND submitted='1' AND dateinserted>='946702800' AND
dateinserted<='1085247047' AND pr
