Guest mitcho Posted July 14, 2005 Share Posted July 14, 2005 on the right hand side of my page i have the 'information' box, containing links of the documents in my cubecart. i added a new document titled 'California Tan' and it appears as the last link in this box. id like to sort these links by alphabetical order so that it is the second link. how would i achieve this? http://lavalounge.com.au/shop/index.php Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2005 Share Posted July 14, 2005 I have a mod that will allow you to set your documents in whatever order you want them to appear: http://cc.dbookbooth.com/view_product.php?product=320 If you just want things alphabetical though, find this line in information.php: $sql_select = mysql_query( "select doc_id, doc_name from ".$prefix."store_docs"); And change it to: $sql_select = mysql_query( "select doc_id, doc_name from ".$prefix."store_docs ORDER BY doc_name"); Quote Link to comment Share on other sites More sharing options...
Guest mitcho Posted July 14, 2005 Share Posted July 14, 2005 thanks alot booker. that solved my problem. i did SQL last year, should have known this... thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.