"TEST DB ACCESS"의 두 판 사이의 차이

1번째 줄: 1번째 줄:
= First section header =
+
= 탄창 =
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
 
|fields= ITEM_SHOP_TYPE=종류, CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,  
 
|fields= ITEM_SHOP_TYPE=종류, CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,  
|where=ITEM_SHOP_AREA18_NAME='Cubby Blast'
+
|where=ITEM_SHOP_AREA18_NAME='Cubby Blast', ITEM_SHOP_TYPE=Magazine
 
|column widths=90px,90px, 90px
 
|column widths=90px,90px, 90px
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}
 
  
 
{{#switchtablink:Second section header|Click here to go to the next tab...}}
 
{{#switchtablink:Second section header|Click here to go to the next tab...}}
13번째 줄: 12번째 줄:
 
= Second section header =
 
= Second section header =
 
This will be displayed on the second tab
 
This will be displayed on the second tab
 
<headertabs/>
 
= Third section header =
 
 
This will be always displayed under the tab view because it's below the <headertabs/> tag.
 

2022년 9월 20일 (화) 00:52 판

탄창

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ITEM_SHOP_TYPE=Magazine ORDER BY `cargo__ITEM_SHOP`.`_pageID`,`ITEM_SHOP_TY...' at line 1 (192.168.2.4:3307)

Function: CargoSQLQuery::run Query: SELECT `cargo__ITEM_SHOP`.`_pageID` AS `cargo_backlink_page_id_ITEM_SHOP`,`ITEM_SHOP_TYPE` AS `종류`,CONCAT('',ITEM_SHOP_KOR_NAME,'') AS `이름`,`ITEM_SHOP_NAME` AS `Name`,`ITEM_SHOP_AREA18_PRICE` AS `가격` FROM `cargo__ITEM_SHOP` WHERE ITEM_SHOP_AREA18_NAME='Cubby Blast', ITEM_SHOP_TYPE=Magazine ORDER BY `cargo__ITEM_SHOP`.`_pageID`,`ITEM_SHOP_TYPE`,CONCAT('',ITEM_SHOP_KOR_NAME,''),`ITEM_SHOP_NAME`,`ITEM_SHOP_AREA18_PRICE`

Click here to go to the next tab...

Second section header

This will be displayed on the second tab