EmailThis Premium lets you save unlimited bookmarks, PDF, DOCX files, PPTs and images. It also gives you a PDF copy of every page that you save. Upgrade to Premium → The following code outputs in order of 1, 10, 11, 12 of id. I want to make it 1,2,3,4... Could anyone tell me what I should do please. $Q = $this->db->query('SELECT P.*, C.Name AS CatName FROM products AS P LEFT JOIN categories C ON C.id = P.category_id');
Thanks in advance. First, add an order by clause at the end: ORDER BY category_id
If category_id is a string, then you must treat it like an integer. There are a few ways to do this. I usually add a zero. You can also cast it. ORDER BY category_id + 0
answered Dec 2 '09 at 14:05 You can do an explicit cast by doing: ORDER BY CAST(category_id AS UNSIGNED INTEGER) But you should reconsider you database layout as a field containing only numeric values should also be of an numeric type.. Best wishes, Fabian answered Dec 2 '09 at 14:28 As previously mentioned MySQL doesn't support alphanumeric sorting. One common trick to solve this is to first order by length: ORDER BY LENGTH(column_name), column_name
As long as the non-numeric part of the value is the same length, this will sort 1 before 10, 10 before 100, etc. answered Mar 24 '17 at 6:19 Make sure that the column that holds 1,2,3,4 is INT type, if it is TEXT, you will not get numerical order, but what you describe 1, 10, 11, 2, 22, 23, 31, etc; And like others mentioned, use ORDER BY answered Dec 2 '09 at 14:06 Order by only working for numerical values(int), not work for varchar, char Your category_id should numerical, otherwise you need to cast values to numerical. answered May 16 '16 at 6:52 Well, you're not setting any ORDER BY clause. answered Dec 2 '09 at 14:05 | | Please check the attached file. EmailThis was not able to extract useful content from the website. Hence, we have saved the webpage to a PDF file. You can find that attached along with this email. | | Upgrade to Premium Plan ✔ Save unlimited bookmarks. ✔ Save PDFs, DOCX files, images and Excel sheets as email attachments. ✔ Get priority support and access to latest features. | | | |
google-chrome-extension
