搜索系统 - 按浏览量排序

	<?php
	foreach ($arr as $key => $value) {
	?>
	<div>
		<a href="view.php?lianjie=<?php echo $value['lianjie']; ?>" target="_blank"><?php echo $value['name']; ?></a>（<?php echo $value['view']; ?>）<br/>
		<?php echo $value['shows']; ?><br/>
	</div>
	<?php
	}
	?>
	
	<div>
		<?php
		for ($i = 1; $i <= $page_count && $i <= 5; $i++) {
			echo "<a href='?search=" . $search . "&page=" . $i . "'>" . $i . "</a>";
		}
		?>
	</div>
</body>

将查询语句修改为按照view的大小进行排序，修改后的代码如下：

$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);

将查询语句中的ORDER BY部分改为ORDER BY search.view DESC，即按照view的大小降序排序。

这样修改后，查询结果将按照view的大小进行排序。