设置按view的大小排序php$search = $_GETsearch;$page = isset$_GETpage $_GETpage 1;$number = 20;$page_max = $page $number;$page_min = $page - 1 $number;$con = mysqli_connectlocalhost us420092414795 pO0qm4xlp
为了按照view的大小排序,需要将查询语句中的ORDER BY子句修改为ORDER BY search.view DESC。修改后的代码如下:
$result = mysqli_query($con, "SELECT * FROM search WHERE (name LIKE '%" . $search . "%' OR lianjie LIKE '%" . $search . "%' OR shows LIKE '%" . $search . "%') ORDER BY `search`.`view` DESC LIMIT " . $page_min . ", " . $number);
这样可以确保查询结果按照view字段的大小降序排列。
原文地址: http://www.cveoy.top/t/topic/iNqT 著作权归作者所有。请勿转载和采集!