Addition with multiple MySQL entries

Question

I have a table and in the table it has several fields that are named L1, L2, L3, and L4. Those fields are just numbers. So, what should the script look like to have L1 through L4 added together where ID='$sID'? Say L1 and L3 have a value of 2 and L2 and L4 have a value of 1 for that user. I would like the page to say '6' so the user can see the total.

Thanks!

Sparkup · Accepted Answer · 2011-06-12 00:48:13Z

2

SELECT L1+L2+L3+L4 AS LTOTAL FROM table WHERE ID = '$sID'

answered Jun 12, 2011 at 0:48

Sparkup

3,7522 gold badges38 silver badges50 bronze badges

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

Comments

Amber · Accepted Answer · 2011-06-12 02:27:08Z

1

SELECT L1+L2+L3+L4 FROM <tablename> WHERE ID=?

and then pass in your ID using the normal mysql prepared statement functions in PHP.

edited Jun 12, 2011 at 2:27

answered Jun 12, 2011 at 0:46

Amber

531k89 gold badges643 silver badges558 bronze badges

Comments

Ben Roux · Accepted Answer · 2011-06-12 01:09:37Z

0

It sounds like you are making the query in PHP and then executing it with a mysql_query(). If that is the case, this line should be the query you are looking for.

$query = "SELECT (L! + L2 + L3 + L4) FROM tableName WHERE id = {$sID}";

php mysql selects have a few functions associated with them, if you are unfamiliar with it, I would suggest looking into it here: http://www.w3schools.com/php/php_mysql_select.asp

edited Jun 12, 2011 at 1:09

answered Jun 12, 2011 at 0:47

Ben Roux

7,4161 gold badge20 silver badges21 bronze badges

Collectives™ on Stack Overflow

Addition with multiple MySQL entries

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related