我使用这个代码来搜索我的sql数据库,它工作,但如果有多个结果,它会显示它们旁边的每个
的例子:
echo "".$row['nick'].""; //would be NAME1NAME2NAME3NAME4
我想显示
NAME1
MORE INFO
NAME2
MORE INFO
NAME3
MORE INFO
.
<?php
$conn = mysql_connect ("*****", "battlefield", "*****") or die ('I
cannot connect to the database because: ' . mysql_error());
$selected = mysql_select_db ("battlefield")
or die ("Could not select database");
// PHP Search Script
$sql = "SELECT * FROM loadout WHERE nick LIKE '%".$_POST['find']."%'";
$result = mysql_query($sql,$conn)or die (mysql_error());
if (mysql_num_rows($result)==0){
echo "Theres no one here called that!";
}else{
while ($row = mysql_fetch_array($result)){
echo "".$row['nick']."";
}
}
mysql_close();
?>
如果您需要html或更多信息,请询问xD
提前感谢!
只需添加<br>
:) !
while ($row = mysql_fetch_array($result)){
echo "".$row['nick']." <a href='link'>MORE INFO</a><br>";
}
或者如果你想在页面的其他地方显示它,将所有结果添加到一个数组中,然后在你想要的地方迭代它们:
存储:
while ($row = mysql_fetch_array($result)){
$results[] = $row['nick']." <a href='link'>MORE INFO</a><br>";
}
显示:
foreach ($results as $result) {
echo $result;
}