$rows = array();$stmt = $pdo->prepare("SELECT variety FROM fruit WHEREORDER BY variety");$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);echo json_encode($rows);
使用上面的代码
我有一个主表(MT),其中包含一个名为Wine_Variety的字段。其中填充了如下所示的数据...CUSTOMER_NUMBER|WINE_VARIETY
1002|CHARDONNAY,MERLOT1004(
sel top 5 variety, '''%'||variety||'%''' as search_string ,sum(qu