I'm trying to figure out how to update a MySQL record (a single row) I cuurently have this but it isn't working... I'm just getting that error "0 is not a mysql result index...." or just the DIE result.
mysql_db_query("guru", "INSERT INTO newslinks (clicks) values('$iClicks') WHERE id='$id'")
or DIE("Unable to insert into database");
$id is a value from an auto_increment col, so it might be "34" or something.
Therefore I want a command to tell Mysql to go to the row with id number "34" and update the col on that row with $iClicks.
Thanks heaps for your time,