Page 1 of 1

adding values of database

Posted: Wed Sep 17, 2008 3:34 am
by zplits
Hi there, does anyone know how to add values that is stored in the database?

for example. I have a table in my database named tbl_add....and below are the fields
name qty
garlic 13
onion 10


what will be the code if i want to add the values of qty? and save it into another table?
like for instance, 13 + 10 = 23. 23 will be stored in another table....

Is this thing possible? if so, please help me. Thanks a lot.