swamp Posted September 11, 2008 Share Posted September 11, 2008 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 More sharing options...
swamp Posted September 11, 2008 Author Share Posted September 11, 2008 don't worry. fixed it. thanks Link to comment https://forums.phpfreaks.com/topic/123820-solved-changing-order/#findComment-639306 Share on other sites More sharing options...
thesaleboat Posted September 11, 2008 Share Posted September 11, 2008 $position++; Link to comment https://forums.phpfreaks.com/topic/123820-solved-changing-order/#findComment-639308 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.