Jump to content

Submit button for Drag and Drop Sorting Lists


datoshway

Recommended Posts

Need some help.  I included the code i'm working with below.  This script is a drag and drop sorting script that updates the mysql on the fly.  I'd like to change that action to a submit button.  Can someone help with compiling that submit code?  Any help is greatly appreciated.

 

 

<script type="text/javascript">
$(document).ready(function(){ 
					   
$(function() {
	$("#contentLeft ul").sortable({ opacity: 0.6, cursor: 'move', update: function() {
		var order = $(this).sortable("serialize") + '&action=updateRecordsListings'; 
		$.post("updateDB.php", order, function(theResponse){
			$("#contentRight").html(theResponse);
		}); 															 
	}								  
	});
});

});	
</script>

</head>
<body>

<div id="contentWrap">
  <div id="contentLeft">
		<ul id="sortable">
			<?php
			$query  = "SELECT * FROM records ORDER BY recordListingID ASC";
			$result = mysql_query($query);

			while($row = mysql_fetch_array($result, MYSQL_ASSOC))
			{
			?>
				<li id="recordsArray_<?php echo $row['recordID']; ?>"><?php echo $row['recordID'] . ". " . $row['recordText']; ?></li>
			<?php } ?>
		</ul>
	</div>

	</div>

 

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.