Napster Posted August 11, 2014 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 196 Reputation: 72 Joined: 12/12/11 Last Seen: November 6, 2016 Share Posted August 11, 2014 i want sort item id and order by name of item A-Z or 0-9how to query for this ? query_sql "SELECT `item_id`FROM "+ $@item_db$ +" WHERE `id`> 0 GROUP BY `item_id` ORDER BY `id` ASC LIMIT 128; thank you Quote Link to comment Share on other sites More sharing options...
Emistry Posted August 12, 2014 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: Monday at 06:22 AM Share Posted August 12, 2014 ORDER BY `name_english` LIMIT 128; Quote Link to comment Share on other sites More sharing options...
Napster Posted August 12, 2014 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 196 Reputation: 72 Joined: 12/12/11 Last Seen: November 6, 2016 Author Share Posted August 12, 2014 @Emistrymap server show error unknow 'name_english' fieldand field item_id = value number only not stringno have idie convert item id --> item name ---> sort name Quote Link to comment Share on other sites More sharing options...
Emistry Posted August 12, 2014 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: Monday at 06:22 AM Share Posted August 12, 2014 change the column name to your item table with appropriate colum name. Quote Link to comment Share on other sites More sharing options...
Question
Napster
i want sort item id and order by name of item A-Z or 0-9
how to query for this ?
thank you
Link to comment
Share on other sites
3 answers to this question
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.