Re: [PHP] contact list re-ordering (php/mySQL CMS design)

2002-09-08 Thread timo stamm
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

[PHP] contact list re-ordering (php/mySQL CMS design)

2002-09-07 Thread speedfreak
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

Re: [PHP] contact list re-ordering (php/mySQL CMS design)

2002-09-07 Thread @ Edwin
I'm not sure if what you mean is something like this: Say, you have a table with 2 columns (1) id and (2) contact. And your table is populated in this way: id contact 1 a 2 b 3 c 4 d 5 e And, let's say that your id is auto_incremented. Also, the contacts are shown ORDER BY