| |
|
|
| |
<?
include "db.php";
$s = mysql_connect("$host", "$user", "$pass");
print <<<HERE
<table width=600 border=1>
<tr>
<td width=10% bgcolor=#F0f0f0># <b>id</b></td>
<td width=20% bgcolor=#F0f0f0><b>Ban time</b></td>
<td width=30% bgcolor=#F0f0f0><b>Reason </b></td>
<td width=20% bgcolor=#F0f0f0><b>Banned at time</b></td>
<td width=20% bgcolor=#F0f0f0><b>Who banned</b></td>
</tr>
HERE;
mysql_connect("$host", "$user", "$pass");
mysql_select_db("$bd");
$sql = ("SELECT * FROM cs WHERE ip LIKE '%$userip%' order by id DESC");
if(!$sql) {
echo "No responding from Mysql";
echo "</table>";
exit();
}
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$id=$row[id];
$ip=$row[ip];
$srok=$row[srok];
$reason=$row[reason];
$time=$row[time];
$admin=$row[admin];
print <<<HERE
<tr>
<td width=10%>$id</td>
<td width=20%>$srok</td>
<td width=30%>$reason</td>
<td width=20%>$time</td>
<td width=20%>$admin</td>
</tr>
HERE;
}
echo "</table>";
mysql_close($s) or die("no connect from mysql");
?>
|
при запросе выдаёт все данные хранящиеся в БД, а не по конкретному айпи, помогите...
тип колонки с айпи text | |
| |
|
