I have a list of DVD's on my site and it sucks when I have to add a new title. There are 94 titles so far and I just had to add 3 of them. They're sorted by ID as sorting by title can't work because of this: Alien Alien 2 Aliens Alien Legacy
It'll show as this: Alien Aliens Alien 2 Alien Legacy
The problem is that I now had to change the IDs in about 80 fields or it wouldn't order correctly anymore. What's the best way to order them without having to edit all the ID's every time?
I tried changing the ID from "number" to "text" and changed the ID's so it'd be a01, a02, a03 etc. That's fine when I sort them on my DVD page, but I can't get the information displayed on the second page ... it gives me a problem in the SQL statement where it's executed.
Topic Locked
Posted - 13 April 2002 : 15:14:52
