Hi speedfreak,
uh, clients. Can't they just send the checks an be content? :-) I have yet not done a user-sorted list in PHP/MySQL (I am using PHP since a week, now :-). But I think the following database setup should allow you to do it: id content above below 1 lala start 2 2 blah 1 3 3 sdfg 2 5 5 oll 3 end By referencing to the entry displayed above/below, you can quite easily write functions for getting the list and for moving rows. Timo Am Samstag den, 7. September 2002, um 18:08, schrieb [EMAIL PROTECTED]: > Dear guru's, > > Hit a problem while developing a CMS with php/mySQL. Part of this is a > contact list and this works ok (add/edit/delete with > insert/update/delete queries). Now the client has requested a new > feature: ability to change the order in which the contacts are being > presented in the public part of this CMS (don't ask me why). I've added > a field 'show_pos' to the contacts table and am able to change > its value > when I edit an existing record or add a new one. What I can't wrap my > head around at the moment is how one deals with updating 'show_pos' for > the OTHER records (while editing/deleting present record (WHERE > id='$id')? Could anyone give me some pointers as to how this could be > done in php and/or SQL (preferable). I sure hope anyone > understands what > I mean ... > > Cheers! > > newbie@a_loss > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
