SQL Query Help Needed
2014-08-03, 12:41 AM,
#1
Hey,

for example:
Someone has 10 dollar on his account.
He purchases a 8 dollar product.

What is the SQL query to substract the 8 from his account?

Thanks for helping.
Reply
2014-08-03, 12:51 AM,
#2
it is rather easy , need two things , full database administration and website in php

for connection you need google help , get a code for database connection ,
it would give your php script database admin power

then,
get value from that column using: select price from table where id= this and this

then perform calculations , any

then use update query : Insert into

нα¢кιηg ιѕ ησт α ¢яιмє, ιѕ αη αят.
Reply
2014-08-03, 12:54 AM,
#3
(2014-08-03, 12:51 AM)cpa(newbie) Wrote: it is rather easy , need two things , full database administration and website in php

for connection you need google help , get a code for database connection ,
it would give your php script database admin power

then,
get value from that column using: select price from table where id= this and this

then perform calculations , any

then use update query : Insert into
I thought it was just a simple query, I used this method in C# once too, thanks for helping :D
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Traffic needed for cpa offers naulodesign 7 293 2017-10-06, 01:50 AM
Last Post: stephanie12
  No conversion help needed total newbie naulodesign 3 169 2017-09-21, 12:58 PM
Last Post: PRINC3
  Needed help with cent os 7 PoS3!DoN 3 90 2017-09-15, 12:23 AM
Last Post: GopherDomains
  Please!!! Suggestions needed for more online business models (cpa apart!)? HAkorehdeh 3 97 2017-09-03, 11:25 AM
Last Post: Watt
  Fraudfilter Campaign Setting Error - Urgent Help Needed. intkhab 2 181 2017-08-08, 01:53 PM
Last Post: intkhab




About Us | Contact Us | CPA Elites | Advertise | Stats | Staff Team

© 2013-2017 CPA Elites Ltd
Enhanced by MyBB and WallBB
Return to top