Sorting with numbers.........

tannaz

Hello,
I'm really new here and I'm just learning, can someone help me?

I have a category that includes invidual categories that they all coming from the database and I want to have ability to have numbers on the side and rearrange them with those number. For example if I have number 1-10 and I want number 4 goes to 1, 3 goes to 5 and so...... CAN SOMEONE PLEASE HELP ME?

Thank you so much!😕

dagon

I have no idea what you are actually asking

tannaz

Creating sortable lists with PHP or MySQL but not click and drag by having a box with numbers....

dagon

Please provide some sort of example of what you are trying to achieve.

tannaz

If you go to blockbuster or netflix you'll see what I mean.

Think we have:
1 text
2 text
3 text
4 text
5 text
and I want the number 2 replace the number 5 and number 3 goes to replace number1.

If you help me....god! you're the angel...... I can't think anymore.

nullifi

So, your wanting to basically change the priority of a certain category by editing its number in the list?

That seems easy enough, just make sure the cats keep a number that you sort by, and then, sort, by that. Right? 😐

tannaz

Yes but it works sometimes not all the time.
For example if I have
1
2
3
4
5
and I want to change number 3 to go to1 it works but if I want to change number 5 to 4 it doesn't work.

nullifi

What happens to the number that is being replaced? Does it get put at the end of the list, or do you manually switch the numbers around?

tannaz

no if I change 5 to go to 3, 3 will go to the number after. Basically the number we change goes one number down.

nullifi

Ahh, 3 becomes 1, 1 becomes 2, etc?
Whats the code that changes the numbers, or displays them or something... Perhaps its just me, but I really don't see how there could be a problem. Seems like it all should work fine and well.

tannaz

I think this part something is wrong:

<? 
// update sort order  
if (isset($_POST['update']) || isset($_POST['pass'])){

	$sql= mysql_query("select * FROM resource_category") or die (mysql_error());
	$num = mysql_num_rows($sql);

	for($j=1;$j<($num+1);$j++){

		$member_id="id_".$j;
		$order_id="order_".$j;
		$member_order="location_".$j;
		$id=$_POST[$member_id];
		$order=$_POST[$order_id];
		$location=$_POST[$member_order];

		mysql_query("UPDATE resource_category SET location='$location'  WHERE cate_id='$id' ") or die(mysql_error());

		if ( $order != $location ){ 
			mysql_query("UPDATE resource_category SET location_date=now() WHERE cate_id='$id' ") or die(mysql_error()); 
		}
	}

} 
?>


<?
// get resource directory data
$quest = mysql_query("SELECT resource_category.cate_id AS category_id,resource_category.location AS location,resource_category.hit AS hits,resource.cate_id AS resource_cate_id, resource_category.cate_title AS title, count(resource.cate_id) AS numbers FROM resource_category LEFT JOIN resource  ON resource_category.cate_id = resource.cate_id GROUP BY resource_category.cate_id ORDER BY location ASC,location_date DESC");	
?>

<table width="593" cellpadding="0" cellspacing="0" border="0" align="center" class="admin_member">
<tr>
	<th>Order</th>
	<th align="left">Category</th>
	<th>Entries</th>
	<th>Hits</th>
	<th>E/D</th>
</tr>
<form method="post" action="<?=$_SERVER["PHP_SELF"]?>">
<?
	$i=1;
	while( $row = mysql_fetch_assoc($quest)) {

		// alternate row color
		$classname = ($i % 2) ? 'odd1' : 'even1';	
?>
		<tr>
		<td class="<?=$classname;?>" width="10%"  align="center"><input type="text" name="location_<?=$i;?>" value="<?=$row['location'];?>" size="1"></td>
		<td width="50%" align="left" class="<?=$classname;?>">
			<input type="hidden" name="order_<?=$i;?>" value= "<?=$row['location'];?>">
			<input type="hidden" name="id_<?=$i;?>" value= "<?=$row['category_id'];?>">
			<a href="admin_view_resource.php?cate_id=<?=$row['category_id'];?>" class="delete"><?=stripslashes(htmlspecialchars($row['title']));?></a>
		</td>
		<td width="10%" align="center" class="<?=$classname;?>"><?=$row['numbers'];?></td>
		<td width="20%" align="center" class="<?=$classname;?>">
			<span><?=$row['hits'];?></span>&nbsp;<a HREF="javascript:popUp('admin_resources_reset.php?hit=<?=$row['category_id'];?>')" class="delete">(reset)</a>
		</td>
		<td width="10%" align="center" class="<?=$classname;?>">
			<!-- <a href="#" class="delete" id="<?=$row['id'];?>"  onclick="show_edit(this)"><img src="images/edit.gif" border="0"></a> -->
			<a href="admin_edit_service_privder.php?cate_id=<?=$row['category_id'];?>"><img src="images/edit.gif" border="0"></a>
			&nbsp;
			<a HREF="javascript:popUp('admin_delete_rseource_category_new.php?cate_id=<?=$row['category_id'];?>')" class="delete"><img src="images/delete.gif" border="0"></a>
		</td>
		</tr>
<?
		$i++;
	}

?>
</table>

<?php