长话短说,我的字段顺序似乎不适合我的MySQL调用。我无法在存储中找到模式...
$ theorder正确设置为
, 'People-Wedding Photo', 'People-Kids', 'People-Male/Female', 'Architecture-Exterior', 'Architecture-Interior', 'Animal-Birds', 'Backgrounds'这是我的代码。正如你所看到的,我正在循环,做我的格式转换....但我仍然得到一个错误的顺序...一个随机命令....
有什么我失踪?
$under_link_query = mysql_query("SELECT DISTINCT(type), type FROM ".$prefix."ProFolio_work WHERE type != 'Backgrounds' ORDER BY FIELD(type" . $theorder .")");
while($u_row = mysql_fetch_assoc($under_link_query)){
$type = html_entity_decode($u_row['type']);
$typeForm = preg_replace('/[^a-z0-9]/i', '_', $type);
?>
echo ucfirst($type); ?>