I'm starting to work with mysql (but I think my post applies to other
databases as well) and I've come across a problem - I've read in several
sources that the order of retrieved rows by a SELECT statement is
undefined unless you use GROUP BY or ORDER BY. Now I need to be able to
fetch the rows in an order defined by me or the web site's owner.
Imagine that each row represents one product in a shop. Now I need to
let the shop owner decide in which order the products appear on a web
page. He needs to be able to freely change this order at any time and
move any product to any position he wants. What would be the easiest way
to accomplish this in a database knowing I can't change the row order? I
will be grateful for any ideas.
Melon.
Received on Sat Dec 20 2003 - 14:36:29 CST
