[SOLVED] changing order

[swamp]

I've written this code to +1 to $position when you submit the form. Problem is it just makes all the numbers 1 instead of adding 1??

 

So if the position was currently 5 i want it to make the position 6. etc..

 

if (isset($_POST['move_up'])) {
$file_ed = $_POST['edit_id'];
$pro_open = $_POST['pro_id'];
mysql_query("SELECT id, project_id, file_name, file_date, file_location, position, approved FROM files WHERE id='$pro_open'", $linkID) or die (mysql_error());	
	  $position = $data[5];
          $nextorder = $position + 1;
          $results = mysql_query("UPDATE files SET position=$nextorder WHERE id='$pro_open'");

 

Any help appreciated! Cheers

[swamp]

don't worry. fixed it. thanks

[thesaleboat]

$position++;