[SOLVED] add in Update query

[gple]

I am passing a integer variable as $paid.

 

I want to run an update query so that it adds the amount to a particular column:

 

mysql_query("UPDATE captains_list SET amount_paid=amount_paid+$payment where id='$id'");

 

this code obviously does not work. can someone look at this.

 

[revraz]

That should work fine, what's the error.

[gple]

there is no error, nothing happens

[mrMarcus]

where did $payment come from?  did you mean $paid?

[gple]

yes, i meant $paid

 

[nankoweap]

this may be a stupid question, but you connected to the database, right? why not pass that resource link in your query statement so there are no assumptions? what about the id column? how are you obtaining the appropriate ID value to update? what's the value returned from mysql_num_rows after the update is performed?

 

jason

[gple]

I put the query within an if statement and it is failing.

[gple]

figured it out.

[nankoweap]

and the problem was?

[mattal999]

My guess - There was nothing wrong. That statement doesn't echo anything after completing itself...

[nankoweap]

hehe. i was assuming he was validating the update with a query from the command line or something.