Jump to content

[SOLVED] changing order


swamp

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/123820-solved-changing-order/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.