*************

SQL code: Upload dump Copy Format Clear

-- Hint: use Ctrl+Enter for SQL autocomplete -- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE menu (`mid` int, `parent` varchar(4), `sub` varchar(4), `org` int, `item` varchar(50), `price` varchar(50), `dsc1` varchar(255), `dsc2` varchar(255)) ; INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (1,NULL,NULL,1,'Apple',NULL,NULL,NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (2,1,NULL,1,'iPhone ','$500','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (3,1,2,1,'iPhone Plus','$600','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (4,1,2,1,'iPhone Red','$900','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (5,1,NULL,1,'MacBook Pro','$1200','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (6,NULL,NULL,1,'Acer',NULL,NULL,NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (7,6,NULL,1,'Laptop ','$500','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (8,6,NULL,1,'Elitebook ','$700','(HI)',NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (9,NULL,NULL,1,'ASUS',NULL,NULL,NULL); INSERT INTO `menu` (`mid`,`parent`,`sub`,`org`,`item`,`price`,`dsc1`,`dsc2`) VALUES (10,9,NULL,1,'Machine ','$500','(HI)',NULL);

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php $stmt = $pdo->query(" SELECT `menu`.`item` as `parent_item`, `mid_menu`.`price` as `mid_menu_price`, `mid_menu`.`item` as `mid_menu_item`, `sub_menu`.`price` as `sub_menu_price`, `sub_menu`.`item` as `sub_menu_item` FROM `menu` JOIN `menu` as `mid_menu` ON `menu`.`mid` = `mid_menu`.`parent` AND `mid_menu`.`sub` IS NULL LEFT JOIN `menu` as `sub_menu` ON `sub_menu`.`sub` = `mid_menu`.`mid` WHERE `mid_menu`.`parent` IS NOT NULL"); while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) { echo implode(' ', $row) . "\n"; }

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online