Forum PHP.pl

[PHP] pobierz, plaintext 
function position_category_up($id_category, $position, $position_site, $isset) {
	if($isset == 'position_up') {
		$select_p_c = "SELECT * FROM site_category WHERE id_position < '".$position."' AND position = '".$position_site."' ORDER BY id_position DESC LIMIT 1";
		$query_p_c = mysql_query($select_p_c) or die(mysql_error());
		$array_p_c = mysql_fetch_array($query_p_c);
 
		$new_position = $array_p_c['id_position'];
		$old_position = $position;
 
		$edit_new_position_update = "UPDATE site_category SET id_position = '".$new_position."' WHERE id_position = '".$old_position."' AND position = '".$position_site."'";
		$edit_new_position_query = mysql_query($edit_new_position_update) or die(mysql_error()); 
 
		$edit_old_position_update = "UPDATE site_category SET id_position = '".$old_position."' WHERE id_position = '".$new_position."' AND id_category = '".$array_p_c['id_category']."' AND position = '".$position_site."'";
		$edit_old_position_query = mysql_query($edit_old_position_update) or die(mysql_error());
 
		if(!$edit_new_position_query && !$edit_old_position_query) {
			echo '<tr><td id="text_formularz_potwierdzenie">Nie można zmienić pozycji!</td></tr>';
		}
	}
}
 
function position_category_down($id_category, $position, $position_site, $isset) {
	if($isset == 'position_down') {
		$select_p_c = "SELECT * FROM site_category WHERE id_position > '".$position."' AND position = '".$position_site."' ORDER BY id_position ASC LIMIT 1";
		$query_p_c = mysql_query($select_p_c) or die(mysql_error());
		$array_p_c = mysql_fetch_array($query_p_c);
 
		$new_position = $array_p_c['id_position'];
		$old_position = $position;
 
		$edit_new_update = "UPDATE site_category SET id_position = '".$new_position."' WHERE id_position = '".$old_position."' AND position = '".$position_site."'";
		$edit_new_query = mysql_query($edit_new_update) or die(mysql_error()); 
 
		$edit_old_update = "UPDATE site_category SET id_position = '".$old_position."' WHERE id_position = '".$new_position."' AND id_category = '".$array_p_c['id_category']."' AND position = '".$position_site."'";
		$edit_old_query = mysql_query($edit_old_update) or die(mysql_error());
 
		if(!$edit_new_query && !$edit_old_query) {
			echo '<tr><td id="text_formularz_potwierdzenie">Nie można zmienić pozycji!</td></tr>';
		}
	}
}
[PHP] pobierz, plaintext