update ip

[web_master]

Hello,

 

how can I update automatic generated (autoincrement) IP? - mean change it to another nr?

 

The code below dont work

 

thnxs

 

T

 

 

<?php
$query_update = mysql_query("UPDATE `news` SET
	`news_id`			= '".$_POST['news_id']."'
WHERE
	`news_id`			= '".$_POST['news_id']."'
");
?>

[BlueSkyIS]

UPDATE some_table SET some_value = (some_value + 1) WHERE id = 'an_id'

[web_master]

OK, BlueSky but

 

UPDATE some_table SET some_value = (some_value + 1) WHERE id = 'an_id'

 

what if I want to change ID nr from 10 to 15 than from 15 to 11 ?

[BlueSkyIS]

OK, BlueSky but

 

UPDATE some_table SET some_value = (some_value + 5) WHERE id = 'an_id'

 

what if I want to change ID nr from 10 to 15 than from 15 to 11 ?

[947740]

And if you want to subtract, you would use - 5.