SQL Programming

Question

I have this select sql query:

$sql = "SELECT `smth`,`smths`,`smthss` FROM sometbl WHERE `smt`='$smt' AND `smts`='$smts'";

How to substract the smth field from $smt ?

Sorry, I don't understand. Can you present a before and after overview of the data to give a better idea. Also, I take it you mean 'subtract' and not 'substitute'? — Mutation Person
– Mutation Person, Commented Jul 29, 2010 at 13:20
@NullUserException: You phrased that much more politely than I would have — Binary Worrier
– Binary Worrier, Commented Jul 29, 2010 at 13:20
WHERE smt='$smt - smth field' ,but in SQL ,without PHP (I know how to do it with PHP).Sorry for my bad English — user370306
– user370306, Commented Jul 29, 2010 at 13:20

Mithun Sreedharan · Accepted Answer · 2010-07-29 13:22:30Z

1

Try

$sql = "SELECT (smt-smth) as diff, smth, smths, smthss FROM sometbl WHERE smt='$smt' AND smts='$smts'";

edited Jul 29, 2010 at 13:22

answered Jul 29, 2010 at 13:19

Mithun Sreedharan

51.6k72 gold badges185 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pranay Rana · Accepted Answer · 2010-07-29 13:22:57Z

1

just subtract ($smt-smth)

SELECT  ($smt-smth) as differance, `smth`,`smths`,`smthss` FROM sometbl WHERE `smt`='$smt' AND `smts`='$smts'

answered Jul 29, 2010 at 13:22

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

Comments

はると · Accepted Answer · 2010-07-29 13:21:26Z

0

$sql = "SELECT ($smt - smth) as smth,`smths`,`smthss` FROM sometbl WHERE `smt`='$smt' AND `smts`='$smts'";

answered Jul 29, 2010 at 13:21

はると

1,5098 silver badges20 bronze badges

Comments

paxdiablo · Accepted Answer · 2010-07-29 13:26:43Z

0

To subtract the smth field from smt in the where clause (as you indicate in one of the comments), use:

$sql = "SELECT `smth`,`smths`,`smthss` FROM sometbl WHERE `smt`='$smt' - `smth` AND `smts`='$smts'";

This will pass the:

 - `smth`

as-is through to the DBMS, not interpreted by PHP.

edited Jul 29, 2010 at 13:26

answered Jul 29, 2010 at 13:20

paxdiablo

888k243 gold badges1.6k silver badges2k bronze badges

Collectives™ on Stack Overflow

SQL Programming

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related