I have a general "how do you do that" SQL question.
I have a table with links in it. One link per row, with URL link name, etc.
The client wants to be able to specify the order in which the links appear.
In other words, they want to set any link to show up first, another other
link to show up second, etc, etc.
I did a rough think like this a while back, by allowing then to set a
"precedent" field, than the sorted on that field. The trick is, of course,
if they ad a link and want it to show up in the second slot, then the
"precedence" filed for records higher then 2 need to be incremented by one,
so the sequence will still be in tack.
I'm thinking there must be a better way to do this, but I don't know what it
is.
Thanks in advance,
Peter Janett
New Media One Web Services
================================
WEB HOSTING FOR WEB DEVELOPERS
================================
Sun, IRIX, Windows 2000, Linux;
PHP, MySQL, Perl, Cold Fusion,
MS SQL, ASP, SSI, SSL
http://www.newmediaone.net
[EMAIL PROTECTED]
(303)828-9882
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
