Selecting A Specific Column

[PunkGo]

hey, ok...what i want to do basiaclly is for someone to login...then if they click on something....add or subtract a number from a field named points but the prob is i need to know how to like select THAT users column (points) and not someone else's or the whole thing...and just update THAT specific field...how would i do this./

[drawmack]

you can't have any sql without a database structure.
how can you have any sql without a database structure?

[PunkGo]

the db is alrdy there...i just need to know the php.

[drawmack]

hey spanky the php is actually sql and we can't tell you the sql if you don't tell us the layout of the db.

Here is the best I can do with no info about your db:

$sql = "UPDATE <table> SET Field = (Field - x) WHERE Field2 = $var"
mysql_query($sql) or die("The query didn't work, probably because you didn't modify it the same as you didn't post your structure.");