{"id":6105,"date":"2022-09-01T10:05:55","date_gmt":"2022-09-01T04:35:55","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/"},"modified":"2022-09-01T10:05:55","modified_gmt":"2022-09-01T04:35:55","slug":"solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/","title":{"rendered":"[Solved] Listing data from database in hierachy and returning it in that order to the database"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-47845341\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"47845341\" data-parentid=\"47844111\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<blockquote>\n<p>NOTE : Since <strong>order<\/strong> is a reserved keyword you can use any other<br \/>\n  name for the column<\/p>\n<\/blockquote>\n<p>This can be achieved by taking <strong>order<\/strong> column in your table.<\/p>\n<p>For Eg:<\/p>\n<pre><code>id  taskname    order\n1   firsttask   1\n2   firsttask   2\n3   firsttask   4\n4   firsttask   3\n5   firsttask   5\n<\/code><\/pre>\n<p>Then while fetching get it <strong>order by asc<\/strong> for <strong>order<\/strong> column<\/p>\n<pre><code>SELECT * FROM tasks ORDER BY order ASC\n<\/code><\/pre>\n<p>Now you may allow the user to add the order in which the items look like by text box or dragable of jquery and then while storing in the database table you can store it via that order<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Listing data from database in hierachy and returning it in that order to the database <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] NOTE : Since order is a reserved keyword you can use any other name for the column This can be achieved by taking order column in your table. For Eg: id taskname order 1 firsttask 1 2 firsttask 2 3 firsttask 4 4 firsttask 3 5 firsttask 5 Then while fetching get it order &#8230; <a title=\"[Solved] Listing data from database in hierachy and returning it in that order to the database\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\" aria-label=\"More on [Solved] Listing data from database in hierachy and returning it in that order to the database\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,339],"class_list":["post-6105","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] NOTE : Since order is a reserved keyword you can use any other name for the column This can be achieved by taking order column in your table. For Eg: id taskname order 1 firsttask 1 2 firsttask 2 3 firsttask 4 4 firsttask 3 5 firsttask 5 Then while fetching get it order ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-01T04:35:55+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Listing data from database in hierachy and returning it in that order to the database\",\"datePublished\":\"2022-09-01T04:35:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\"},\"wordCount\":112,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\",\"name\":\"[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-01T04:35:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Listing data from database in hierachy and returning it in that order to the database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb","og_description":"[ad_1] NOTE : Since order is a reserved keyword you can use any other name for the column This can be achieved by taking order column in your table. For Eg: id taskname order 1 firsttask 1 2 firsttask 2 3 firsttask 4 4 firsttask 3 5 firsttask 5 Then while fetching get it order ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/","og_site_name":"JassWeb","article_published_time":"2022-09-01T04:35:55+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Listing data from database in hierachy and returning it in that order to the database","datePublished":"2022-09-01T04:35:55+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/"},"wordCount":112,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/","url":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/","name":"[Solved] Listing data from database in hierachy and returning it in that order to the database - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-01T04:35:55+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-listing-data-from-database-in-hierachy-and-returning-it-in-that-order-to-the-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Listing data from database in hierachy and returning it in that order to the database"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/6105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=6105"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/6105\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=6105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=6105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=6105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}