Question

我有以下声明:

$search = "SELECT Scene, Divinite, Attestation
    FROM SceneDivList
    WHERE BINARY Divinite =  $target 
    ORDER BY FIELD( Scene);
$result = mysql_query($search, $con);

In this case the result will be alphabetically order based on the field scene .

有可能根据以下字母顺序而不是按字母顺序排列结果:

$alphabet = array( 1 =>  -  , 2 =>  ,  , 3 =>  .  , 4 => "A",
                   5 => "j", 6 => "a", 7 => "w", 8 => "b", 
                   9 => "p", 10 => "f", 11 => "m", 12 => "n", 
                   13 => "r", 14 => "h", 15 => "H", 16 => "x", 
                   17 => "X", 18 => "s", 19 => "S", 20 => "q", 
                   21 => "k", 22 => "g", 23 => "t", 24 => "T", 
                   25 => "d", 26 => "D");

结果是:

SCENE            ATTESTATION
jnD-Hr-m-nms,t  DI.80,11
jrp             DI.26,12
jrT,t           DI.116,17
aAb,t           DI.138,8
anx             DI.12,5
antjw           DI.148,10
wADw-msdm,t     DI.144,11
bHsw            DI.115,9
pr-n-nb=f           DI.17,7

Answer 1

最为清洁的解决办法是:,并具体规定Scene栏应当使用。如果你这样做,询问将简单地改为<代码>。页: 1 FIELD(Scene) 没有意义——你是否检查了 .FIELD?

除此以外,你还可以根据<编码>战略_REPLACE,将data改为校对,而不是在校对,但我却胜过。

当然,你可以回避所有这一切,并在项目组合中进行分类,因为项目组合将更加方便,但这种办法将无法解决与必须自行分类的分局合并的提问。

Answer 2

回答是最佳解决办法。但是,在这里,对你们来说,是一种残酷的“基地”解决办法。

$alphabet = array( 1 =>  -  , 2 =>  ,  , 3 =>  .  , 4 => "A",
               5 => "j", 6 => "a", 7 => "w", 8 => "b", 
               9 => "p", 10 => "f", 11 => "m", 12 => "n", 
               13 => "r", 14 => "h", 15 => "H", 16 => "x", 
               17 => "X", 18 => "s", 19 => "S", 20 => "q", 
               21 => "k", 22 => "g", 23 => "t", 24 => "T", 
               25 => "d", 26 => "D");

$replace_engine =  Scene ;                   
foreach($alphabet as $k=>$char) {
    $charint = sprintf("%03s",   $k);
    $replace_engine = "REPLACE(".$replace_engine.", $char , $charint )";
}


$query = "SELECT $replace_engine as myalphabet, Scene FROM SceneDivList ORDER BY myalphabet";

Answer 3

There are two solutions: 1) order after query directly in code. the drawback is you always need to gather all the results so you could have performance problems. 2) add a column to the table with the ordering values based on the index of your array.

也许你可以创造我的奇克勒功能,以命令......,但我不知道习惯的神话功能。

......和约恩提出的地雷前2个雷区的解决办法:D

Answer 4

尽管若能回答是正确的办法,但你可能希望通过建立一个表格(ID, C)来尝试迅速和 d脏的版本,其中国际发展法(autoincrement)是分类,而C是VARCHAR(1)。

With joins the ordering could be achieved to whatever level is required.

$search = "SELECT s.Scene, s.Divinite, s.Attestation
FROM SceneDivList s
INNER JOIN CustomOrder o1 ON o1.C = SUBSTRING(s.Scene,0,1)
INNER JOIN CustomOrder o2 ON o2.C = SUBSTRING(s.Scene,1,1)
INNER JOIN CustomOrder o3 ON o3.C = SUBSTRING(s.Scene,2,1)
WHERE BINARY s.Divinite =  $target 
ORDER BY o1.ID, o2.ID, o3.ID, SUBSTRING(s.Scene,4);
$result = mysql_query($search, $con);

注:虽然可以快速地进行这项工作,但搁置问题本身将比以前缓慢。

Answer 5

如果你想用粗略的方式来替代一个领域,那么你需要一种在PHP中重新发挥功能,以产生以下特征:

function replace( $fields ) {
    if( empty( $fields ) ) return( "`Scene`" );

    $t = each( $fields );
    $pop = array_shift( $fields );

    return( sprintf(
        "replace(%s,  %s ,  %s )",
        replace($fields),
        $t[ key ],
        str_pad($t[ value ], 3,  0 , STR_PAD_LEFT )
    ));
}

$alphabet  = array( 1 =>  -  , 2 =>  ,  , 3 =>  .  , 4 => "A",
                   5 => "j", 6 => "a", 7 => "w", 8 => "b", 
                   9 => "p", 10 => "f", 11 => "m", 12 => "n", 
                   13 => "r", 14 => "h", 15 => "H", 16 => "x", 
                   17 => "X", 18 => "s", 19 => "S", 20 => "q", 
                   21 => "k", 22 => "g", 23 => "t", 24 => "T", 
                   25 => "d", 26 => "D");



$sql = sprintf(
"SELECT Scene, Divinite, Attestation, %s as `neworder`
FROM SceneDivList
WHERE BINARY Divinite =  %s 
ORDER BY `neworder`", 
    replace(array_flip( $alphabet  )),
    "target <- whatever that is"
);

echo $sql;

At this point $sql will contain the following query:

SELECT Scene, Divinite, Attestation, 
replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(replace(
`Scene`,  D ,  026 ),  d ,  025 ),  T ,  024 
),  t ,  023 ),  g ,  022 ),  k ,  021 ),  q ,  020 
),  S ,  019 ),  s ,  018 ),  X ,  017 ),  x ,  016 
),  H ,  015 ),  h ,  014 ),  r ,  013 ),  n ,  012 
),  m ,  011 ),  f ,  010 ),  p ,  009 ),  b ,  008 
),  w ,  007 ),  a ,  006 ),  j ,  005 ),  A ,  004 
),  . ,  003 ),  , ,  002 ),  - ,  001 
) as `neworder`
FROM SceneDivList
WHERE BINARY Divinite =  target <- whatever that is 
ORDER BY `neworder`

友情链接