Beginner Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Other > Beginner Programming
Reload this Page

how do I enter the code to "add up" im MySQL

Discuss how do I enter the code to "add up" im MySQL in the Beginner Programming forum on Dev Shed.
how do I enter the code to "add up" im MySQL Beginner Programming forum discussing problems and solutions for just about any issue. Experienced programmers offer their help to those just starting out.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 29th, 2002, 04:24 AM
strawpuppy strawpuppy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 5 strawpuppy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
how do I enter the code to "add up" im MySQL
I have made a website that has a lot of forms which so far are OK, except one part of the form asks for an amount input. This is where I am getting stuck.
How do I get the users numerical input to add up using the MySQL web interface that my ISP has given me.
EG: user inputs "4" in the amount box, which is representing an item for £2.00...how do I get the result to come back as "8"
Appologies if this is not as simple as I'm hoping it is. Any pointers in the right direction would be appreciated.
Thanks in advance
Strawpuppy
Reply With Quote
  #2  
Old December 29th, 2002, 04:45 AM
AlCapone's Avatar
AlCapone AlCapone is offline
Mobbing Gangster
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Sep 2001
Location: "Best City" 2002 and 2003- Melbourne, Australia
Posts: 4,913 AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 5 h 36 m 31 sec
Reputation Power: 18
Send a message via ICQ to AlCapone Send a message via AIM to AlCapone Send a message via Yahoo to AlCapone
For sql side it'll be something like
select <var>*price as total from items
where <var> is from your program.
__________________
And you know I mean that.
Reply With Quote
  #3  
Old December 29th, 2002, 05:16 AM
strawpuppy strawpuppy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 5 strawpuppy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks
I will have a go at that..
It will take a few days as my ISP is sending me a new password to access my cgi-bin...That can take up to a week!
Thanks again
Strawdog
Reply With Quote
  #4  
Old December 30th, 2002, 12:56 AM
AlCapone's Avatar
AlCapone AlCapone is offline
Mobbing Gangster
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Sep 2001
Location: "Best City" 2002 and 2003- Melbourne, Australia
Posts: 4,913 AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 5 h 36 m 31 sec
Reputation Power: 18
Send a message via ICQ to AlCapone Send a message via AIM to AlCapone Send a message via Yahoo to AlCapone
>>as my ISP is sending me a new password to access my cgi-bin
LOL! pffft. Where did you find those dorks?
Reply With Quote
  #5  
Old December 30th, 2002, 01:38 AM
strawpuppy strawpuppy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 5 strawpuppy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Simple
I managed to find a site that listed 100's of ISP's in a table format that included costs, what you get, ratings, ect...plus a simple html link to the site....
They offered £6.99 p\m, 250mb web space, fp extensions, plus all the stuff that I'm now trying to get my head round to use......
This is my 4th ISP in 4 years, and I will try and stick with them cause they really do ....Answer your queries (sort of) and they do....TRY Really HARD......If your in Biz you know what a pain we can be........
Anyhow, my lastest Dumb question if you fancy replying....IS:
Can I download MySQL and use it locally on my Win98, (so I can practice until my ISP gets that password sorted?) Tried finding the answer to that and so far have failed....
Hope it gives you a smile not a groan!
Thanks again
Strawpuppy
Reply With Quote
  #6  
Old December 30th, 2002, 02:21 AM
Zoko Siman's Avatar
Zoko Siman Zoko Siman is offline
Web Monkey
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2001
Location: I refuse to be from anywhere, I am one with the internet
Posts: 76 Zoko Siman User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to Zoko Siman Send a message via AIM to Zoko Siman
Re: Simple
Quote:
Originally posted by strawpuppy
...Anyhow, my lastest Dumb question if you fancy replying....IS:
Can I download MySQL and use it locally on my Win98, (so I can practice until my ISP gets that password sorted?) Tried finding the answer to that and so far have failed....


yes! yes you can!!!

..
..
....

oh, you wanted to know how as well?

A great tool i found was php triad. It installs PHP, Apache, and mySQL. it's quite nice =)

http://sourceforge.net/project/show...elease_id=75430

just get the windows exe it has highlighted, install, and you're set to go.

Enjoy
__________________
Quick, think of something geeky to say before they catch on!
Mozilla is your friend!
Web Site
Reply With Quote
  #7  
Old December 30th, 2002, 02:36 AM
strawpuppy strawpuppy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 5 strawpuppy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks going there now!
Don't be suprised if you see me pm with about 100mb of what the hec's this? and a trolley full of asprin and valium....
Really though!
Thanks Sincerely
Strawpuppy
Reply With Quote
  #8  
Old December 30th, 2002, 02:54 AM
AlCapone's Avatar
AlCapone AlCapone is offline
Mobbing Gangster
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Sep 2001
Location: "Best City" 2002 and 2003- Melbourne, Australia
Posts: 4,913 AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 5 h 36 m 31 sec
Reputation Power: 18
Send a message via ICQ to AlCapone Send a message via AIM to AlCapone Send a message via Yahoo to AlCapone
Hey, strawpuppy, I wasn't groaning. It's just that in this industry it's not a good sign when a company makes you wait for such little things...
Reply With Quote
  #9  
Old December 30th, 2002, 03:15 AM
strawpuppy strawpuppy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 5 strawpuppy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
That I do know...
Oh Al Capone...
The fault is all mine.
I live like a hermit and have lost all of my "Social Skills".
Guess it's just the way it comes out.
Truce?
Reply With Quote
  #10  
Old December 30th, 2002, 03:24 PM
AlCapone's Avatar
AlCapone AlCapone is offline
Mobbing Gangster
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Sep 2001
Location: "Best City" 2002 and 2003- Melbourne, Australia
Posts: 4,913 AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level)AlCapone User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 5 h 36 m 31 sec
Reputation Power: 18
Send a message via ICQ to AlCapone Send a message via AIM to AlCapone Send a message via Yahoo to AlCapone
No worries mate
Reply With Quote
Reply

Viewing: Dev Shed Forums > Other > Beginner Programming > how do I enter the code to "add up" im MySQL

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway. 
Stay green...Green IT