PHP Help!

[IMP_TWI]

I'm having trouble writing a simple query.

I need to select every nickname under table user_characters where a1 is more then 0.. then next I need to multiply c2 by their amount of a1.. So..

example:

If user a has 10 of a1.. and c2 = 200, then multiply c2 * a1.. then I need it to update the db with the new value.. so update set user_characters where blank=blank+$result.

Not sure if anyone understands that or can help but any help would be appreciated.

[IMP_TWI]

c2 will just be a normal variable.

[HalfaBee]

Probably something like this

UPDATE tablename set blank = blank + a1*c2 where a1>0

[IMP_TWI]

I put this as the query:

$queryq = mysql_query("UPDATE user_characters SET cash = cash + 'it' * 200 WHERE item_thug > 0");

But it doesn't do the right math, It does add to the right place but it doesn't add the "it" * "200" no matter if i use quotes or not.

[HalfaBee]

is it a column?
If it is you need to use backticks. eg it

[IMP_TWI]

That seem to work perfectly, thanks 🙂