Hello,
I am trying to reorder the rows in a MySQL database. A typical row withing the DB looks like
ID,CATEGORY,URL
There are a few hundred URLs in each category, each with a unique ID. Surfers will see the links in order according to their ID number. I'd like to assign the URL to another ID number within the same category. Is this possible using MySQL commands or will I have to do some kind of crazy array manipulation? Any ideas would be most appreciated.
I am trying to reorder the rows in a MySQL database. A typical row withing the DB looks like
ID,CATEGORY,URL
There are a few hundred URLs in each category, each with a unique ID. Surfers will see the links in order according to their ID number. I'd like to assign the URL to another ID number within the same category. Is this possible using MySQL commands or will I have to do some kind of crazy array manipulation? Any ideas would be most appreciated.