Click to See Complete Forum and Search --> : increment field by one


habman
08-03-2006, 10:23 PM
I have a table in a MySql database and all I need to do is update a field (called thread) by one if the field is less than a certain value.

Here is what I have so far but I'm not sure what to put into the area with the question mark:

$renumber = mysql_query("UPDATE forum SET thread = ? WHERE thread < 6");


TIA

NogDog
08-03-2006, 10:29 PM
... SET thread = thread + 1 ...