calculate data in table

[Pavlin24]

Hello there,

some help in this?

 

Is it possible to calculate numeric data in table with data coming from forms?

 

I mean something like this:

 

mysql_query("UPDATE ov SET dt_ob=(dt_ob+'$suma1') WHERE smetka='$debit' ",$con)

 

dt_ob and smetka are coloumns in the table,

$suma1 and $debit are data coming from form.

 

 

The code above do not work to me.

[justsomeguy]

If you're trying to add numbers, then remove the quotes. Quoted things are strings, not numbers.

[Pavlin24]

Yes, that may be a problem too. But the main problem was that I had to pass the query trough mysql_fetch_array() function. It works now.

Thank you.