mysql重新排序_Mysql重新排序菜单

如果我有三个菜单

id | name | order

--------------------

1 | Foo | 1

2 | Bar | 2

3 | Blah | 3然后点击链接menu/up/1，我需要设置菜单编号1到2的顺序，菜单编号2到1。

我试过(PDO)

public static function goDown($id) {

if(!$id) {

return false;

}

self::connect();

self::prepare('SELECT count(*) FROM menu');

$count = self::fetch();

if(isset($count['count(*)'])) {

self::prepare('UPDATE menu SET order = order - 1 WHERE order = :count');

self::bindValue('count', $count['count(*)']);

self::execute();

self::prepare('UPDATE menu SET order = order + 1 WHERE id = :id AND order < :count');

self::bindValue('id', $id);

self::bindValue('count', $count['count(*)']);

return self::execute();

}

}谢谢！

编辑 - 我的解决方案：

public static function goDown($id) {

if(!$id) {

return false;

}

self::connect();

self::prepare('SELECT count(*) FROM menu');

$count = self::fetch();

if(isset($count['count(*)'])) {

self::prepare('SELECT ordem FROM menu WHERE id = :id LIMIT 1');

self::bindValue('id', $id);

$ordem = self::fetch();

self::prepare('UPDATE menu SET ordem = ordem - 1 WHERE ordem = :ordem');

self::bindValue('ordem', $ordem['ordem'] + 1);

self::execute();

self::prepare('UPDATE menu SET ordem = ordem + 1 WHERE id = :id AND ordem < :count');

self::bindValue('id', $id);

self::bindValue('count', $count['count(*)']);

return self::execute();

}

}