[Logician]

Originally Posted by OKIHost

I am hoping someone can help me, I added a field in the users profile (field6) which users enter the total amount of weight they have lost. I am trying to add a query which will take all these numbers and add them up to a total I am use on some different pages.

I added the following to a normal webquerie named WQ_totallbs using the following:

SELECT sum( field6 ) AS total
FROM userfield

Then I created a new webtemplate page and tried adding the $WQ_totallbs to the page but nothing shows.

I did this testing in phpmyadmin and it seems to work correctly but it not showing in the webtemplates for some reason.

I am very new to this and just got the query from another user here at vb.org who is doing the same thing, he does it manually and I figured it would be great to add into a webtemplate people can look at for a real-time number instead of manually doing it once a week or whatever.

Any help would be greatly appreciated.

Are you using $WQfield[total] in your Query Result Row section? Also make sure "Advanced Query?" is set to NO.