I working on a manual list order sort function, based on:
www.phpfreaks.com/tutorial/php-custom-list-order
Original:
| Code: |
// swap the rows. Basic idea is to make $id=$swap and $swap=$id
$sql = "UPDATE info SET usort = CASE usort WHEN $id THEN $swap WHEN $swap THEN $id END WHERE usort IN ($id, $swap)";
$result = mysql_query($sql, $conn) or die(mysql_error());
|
I have tried some ways of transform this into fit ZF, but I still pretty new so it don't wont to work.
First I tested:
| Code: |
$data = "CASE usort WHEN $id THEN $swap WHEN $swap THEN $id END";
$this->getDbTable()->update($data, array('id = ?' => $entry->id));
|
Forum