* v0idnull aka Alex Dow. > 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?
I think you will have to manually program this. As I understand it the reorganization will require two rows to change, there is AFAIK no way to make it so that when you change a column in one row, the server will change a column in a different row automatically. When triggers enters the arena, once in the future, then we will probably be able to do stuff like this. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
