Database Discussion

Print Page | Close Window

SUM help

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2762
Printed Date: 29 March 2026 at 2:25pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SUM help

Posted By: Mattblack
Subject: SUM help
Date Posted: 16 May 2003 at 10:25am

hi guys, need SUM help (Sorry for the bad pun).

I need to write some code for my "My Basket" section on my site which will find all results where username=X & password=Y, then SUM of PRICE column from results from search.

Much appreciated people.

~~Matt ( http://www.zeuscomputers.co.uk/ - Www.ZeusComputers.Co.Uk )

Replies:

Posted By: MorningZ
Date Posted: 16 May 2003 at 10:53am

theres a built in SQL function for SUM

http://www.w3schools.com/sql/sql_functions.asp - http://www.w3schools.com/sql/sql_functions.asp

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: Mattblack
Date Posted: 17 May 2003 at 6:19am

thanks for that. What a gr8 website it is. Much help found there.

Matt