Incrementing a mysql count field

M

mljs12

New Member
I have a count field in a table that I need to increment and this is what I have.\[code\]$click_tracker_row = mysql_fetch_array($result);$current_count = $click_tracker_row['count'];$new_count = $current_count + 1;$query_wiki ="UPDATE click_tracker SET count = '{$new_count}' WHERE click_tracker_id = '{$click_tracker_row['click_tracker_id']}' LIMIT 1"; $result = mysql_query($query) ;\[/code\]But it never changes....is there a better way of doing this and why is this not working count is an integer field
 
You must log in or register to reply here.
Back
Top