frost

Just a note on this: SELECT book_id, book, book_display FROM books WHERE book_status = 'active' ORDER BY FIND_IN_SET(book_id, '13,4,5,6,7,8,9,10,2,3' ) LIMIT 0 , 30 this is returning a strange set, the book_id it is returning are (in order given back): 1,12,11,13,4,5,6,7,8,9,10,2,3 To get the proper result I had to provide all 13 book ids, this returned them in the proper order. Hopefully that will help someone else.

The order will be saved as part of there account settings and will be set on login so no worries there. Thanks again.

perfect, thanks for the help guys.

something to try at the top of your file: print_r($_POST); This will spit out everything that is posted so you can see it. Also try: $suffix = $_POST['suffix']; //removed brackets from above echo $suffix;

I ran into a similar problem recently. "view-listings.php?live&id" is the issue, you need to give live a value of some kind. "view-listings.php?live=1&id" would work.

How will that work? If a user sets his account to 1,4,5,6,7,8,9,10,2,3 how can I select those in that order from the table?

Hi, I have a table set up with 10 items in it, I want to allow users to customize the order of the items when they are logged in. How can I call the items from the table in the order set by the user? Thanks for any help.