按功能DESC排序不适用于自定义变量 [英] Order by featured DESC not working for a custom variable
本文介绍了按功能DESC排序不适用于自定义变量的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我具有以下功能,我需要更新$ how,以便在我尝试了多次site_views DESC后按功能视频对视频进行排序,但显示的是相同的输出,或者我得到空的输出.谢谢.因此,我只需要在site_views之后显示精选视频.
I have the following functions , I need to update $how so it sort videos by featured videos after the site_views DESC I tried a lot of times but same output is displaying or I get empty output.Thanks in advance. so i need to display only featured videos after site_views.
function list_videos($how = 'added', $limit = '15') { // newest, top views, etc etc etc
$query = mysql_query("SELECT * FROM pm_videos ORDER BY $how DESC LIMIT $limit");
$result = '';
while ($row = mysql_fetch_array($query)) {
$results .= "
<div class=\"item\">
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\"><img src=\"" . show_thumb($row['uniq_id']) . "\" alt=\"" . $row['video_title'] . "\" class=\"imag\" width=\"107\" height=\"72\" /></a>
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\" class=\"song_name\">
<span class=\"artist_name\">" . fewchars($row['artist'] . " - " . $row['video_title'], 30) . "</span>
</a>
<span class=\"item_views\">" . pm_number_format($row['site_views']) . " views</span>
</div>";
}
return $results;
}
现在我更新了代码,它仅显示精选的vidos,但未订购它们:
function list_featured_videos($how = 'added', $limit = '15') { // newest, top views, etc etc etc
$query = mysql_query("SELECT *
FROM `pm_videos`
ORDER BY `pm_videos`.`featured` DESC
LIMIT 0 , 30");
$result = '';
while ($row = mysql_fetch_array($query)) {
$results .= "
<div class=\"item\">
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\"><img src=\"" . show_thumb($row['uniq_id']) . "\" alt=\"" . $row['video_title'] . "\" class=\"imag\" width=\"107\" height=\"72\" /></a>
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\" class=\"song_name\">
<span class=\"artist_name\">" . fewchars($row['artist'] . " - " . $row['video_title'], 30) . "</span>
</a>
<span class=\"item_views\">" . pm_number_format($row['site_views']) . " views</span>
</div>";
}
return $results;
};
并使用:
$featured = list_featured_videos('added');
请注意,使用添加或site_views会呈现相同的结果.
推荐答案
As seen in your previous question, you need a new, separate function for the display of featured videos:
根据要求进行
function list_featured_videos($sql) { // newest, top views, etc etc etc
$query = mysql_query( $sql );
$result = '';
while ($row = mysql_fetch_array($query)) {
$results .= "
<div class=\"item\">
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\"><img src=\"" . show_thumb($row['uniq_id']) . "\" alt=\"" . $row['video_title'] . "\" class=\"imag\" width=\"107\" height=\"72\" /></a>
<a href=\"" . makevideolink($row['uniq_id'], $row['artist'], $row['video_title']) . "\" class=\"song_name\">
<span class=\"artist_name\">" . fewchars($row['artist'] . " - " . $row['video_title'], 30) . "</span>
</a>
<span class=\"item_views\">" . pm_number_format($row['site_views']) . " views</span>
</div>";
}
return $results;
};
现在您可以使用来调用它
Now you can call this using
$featured = list_featured_videos('SELECT * FROM pm_videos WHERE featured=1 ORDER BY site_views DESC LIMIT 10');
例如.
这篇关于按功能DESC排序不适用于自定义变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文