MySQL get value?

Hello,

I've some tables, one of them is called "server", it is the 18th table in my database. Anyway, that table has three columns, `player_record`, `online`, `onlineplayerpeak`. I wanted to add a code to check if the value inserted in the column `online` is higher than `onlineplayerpeak` then it sets `onlineplayerpeak` to the same value `online` has.

Would be appreciated if someone helps me doing that!

The way I update my `online` column:

Code:

    mysql_tquery(pSQL, "UPDATE `server` SET `value` = `value` + 1 WHERE `name` = 'online';");

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at http://ift.tt/jcXqJW.
Recommended article from FiveFilters.org: Most Labour MPs in the UK Are Revolting.

MySQL get value?