MYSQL Help

[Anon]

How can i add a number to an already existing field in my mysql database

I am making this script counts how many downloads are there.

So.. all this script will do is add a number to the mysql field add redirect to another field in the database.

database name=download
number to add in the field = counter
redirect to field = url
uses the id function to know about the download = id

Can someone help me

[craigh]

one way to do it would be to

1) fetch the value of counter
2) add 1 to counter
3) UPDATE tablename SET counter = $value where counter=$oldvalue

not sure if that's what you're going for.