[SOLVED] Increment all records by 1

[kmark]

Hi,

 

I'm wondering if there is a way that I can increment all the values in a specific field by one by just using a single query.

 

So the original records are:

 

Name

Number

Mark

3

Kevin

10

 

and i want...

 

Name

Number

Mark

4

Kevin

11

[craygo]

<?php
$sql = "UPDATE `tablename` SET `Number` =  `Number`+1";
mysql_query($sql) or die(mysql_error());
?>

 

Ray

 

[jonsjava]

<?php
$sql = "UPDATE `tablename` SET `Number` =  `Number`+1";
mysql_query($sql) or die(mysql_error());
?>

 

Ray

 

curiosity got the best of me. I've never needed to run something like that myself, so my question for you is this: does it start at the bottom (the higest number), and work its way up? If not, that may pose problems for unique sets.  If he is updating `Number` where id =1, and it becomes 2, and there is already one numbered 2....

[craygo]

LOL I don't ask how his data is setup, just answer the question. I know the potential problems with something like this, but I just help give the answer.

 

Ray

[kmark]

Its not an id field, its just if I number employee levels and I want to add one at the top it pushes everything down one.

 

Works great by the way if I get rid of the quotes.

 

Thanks