List:General Discussion« Previous MessageNext Message »
From:v0idnull Date:October 15 2003 12:49pm
Subject:Are there some built in functions that can help me out here?
View as plain text  

Background of problem:

I have lists of information that need to be ordered manually.

Example:


[tblList]
ID  -  TYPE     -  POS
1   -  Name     -  1
2   -  Company  -  2
3   -  Website  -  3

that would be the actual table structure and its data, displayed on a
website.

Now if a user decides he wants "Company" to be on top, he would have to
manually do it, and the end result would be:
(hope you're in plain ASCII)

[tblList]
ID  -  TYPE     -  POS
2   -  Company  -  1
1   -  Name     -  2
3   -  Website  -  3


Now, is there any to automate the reorganization of POS in MySQL or does
this have to be manually programmed in my backend of choice?

Thanks in advance,
Alex Dow.




Thread
Are there some built in functions that can help me out here?v0idnull15 Oct
  • Re: Are there some built in functions that can help me out here?Roger Baklund15 Oct