Mysql UPDATE SyntaxDec 7, 2000
what is wrong with this code? It generates no erros, but doesn't work either:
$query = "UPDATE $usertable SET dl=dl+1 WHERE id=$id";
$result = MYSQL_QUERY($query);
There is a unique id number for every row in my table. There is also a column called "dl" which holds the number of downloads certain files have gotten. I'm trying this code on my download page so that every time someone downloads a file (identified by its id number) the "dl" column for that file is incremented.