![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
[php]
$sql = "SELECT NClassID,NClass,Abcd FROM " . TABLE_PREFIX . "nclass WHERE SClassID='$SClassID' ORDER BY Abcd";
$rs = &$db->Execute($sql);
$tmp = '';
while(!$rs->EOF){
if($tmp != $rs->fields['Abcd']) $tmp = $rs->fields['Abcd'];
$singerlist[$tmp][] = array('NClass' => $rs->fields['NClass'],
'Adcd' => $rs->fields['Abcd'],
'NClassID' => $rs->fields['NClassID']
);
$cachedata = "$"."singerlist[".$tmp."] =". var_export($singerlist[$tmp],true) . ";\n\n";
$rs->MoveNext();
}
$rs->Close();
unset($sql,$rs,$i);
writetocache($cachename,$cachedata);[/php]
这一段是生成[港台]歌手列表的三维数组的代码,
可生成的cache文件中却只有拼音字母“Z”开头的歌手
[php]
<?php
//[tvcd.cn] cache file, DO NOT modify me!
//Created onDec 25, 2006, 4:01
$singerlist[Z] =array (
0 =>
array (
'NClass' => '朱晓琳',
'Adcd' => 'Z',
'NClassID' => '9',
),
1 =>
array (
'NClass' => '周冰倩',
'Adcd' => 'Z',
'NClassID' => '1857',
),
2 =>
array (
'NClass' => '朱哲琴',
'Adcd' => 'Z',
'NClassID' => '7',
),
3 =>
array (
'NClass' => '张蔷',
'Adcd' => 'Z',
'NClassID' => '59',
),
4 =>
array (
'NClass' => '周彦宏',
'Adcd' => 'Z',
'NClassID' => '2015',
),
5 =>
array (
'NClass' => '周敏萱',
'Adcd' => 'Z',
'NClassID' => '1232',
),
6 =>
array (
'NClass' => '祖海',
'Adcd' => 'Z',
'NClassID' => '2',
),
7 =>
array (
'NClass' => '朱明英',
'Adcd' => 'Z',
'NClassID' => '11',
),
8 =>
array (
'NClass' => '朱桦',
'Adcd' => 'Z',
'NClassID' => '12',
),
9 =>
array (
'NClass' => '张也',
'Adcd' => 'Z',
'NClassID' => '48',
),
10 =>
array (
'NClass' => '赵薇',
'Adcd' => 'Z',
'NClassID' => '36',
),
11 =>
array (
'NClass' => '周旋',
'Adcd' => 'Z',
'NClassID' => '18',
),
12 =>
array (
'NClass' => '周艳泓',
'Adcd' => 'Z',
'NClassID' => '17',
),
13 =>
array (
'NClass' => '张浅潜',
'Adcd' => 'Z',
'NClassID' => '60',
),
14 =>
array (
'NClass' => '赵默',
'Adcd' => 'Z',
'NClassID' => '1264',
),
15 =>
array (
'NClass' => '张蝶',
'Adcd' => 'Z',
'NClassID' => '72',
),
16 =>
array (
'NClass' => '朱逢博',
'Adcd' => 'Z',
'NClassID' => '13',
),
17 =>
array (
'NClass' => '周迅',
'Adcd' => 'Z',
'NClassID' => '1665',
),
);
?>
[/php]
其他字母开头的都没生成。看一下是哪个步骤出了问题?
[ 本帖最后由 millken 于 2006-12-25 12:15 PM 编辑 ]

