Файл: g23as/mod9.php
Строк: 12
<?
echo"<u>По IP</u>:<br/>";
$ips=mysql_fetch_array(mysql_query("SELECT ip,ip2 FROM gos WHERE strana='$a'"));
$ip=$ips['ip'];$ip2=$ips['ip2'];if($ip2==0){$ip2=$ip;}
$query="SELECT * FROM gos WHERE ip='$ip' or ip2='$ip2'";
$result=mysql_query($query);$num=mysql_numrows($result);
$i=0;while ($i < $num) {
$p1=mysql_result($result,$i,"strana");
$i++;echo "<u>$p1,</u>";}
echo'<br/>-------------<br/>';echo"<u>По заходам</u>:<br/>";
$ky=mysql_fetch_array(mysql_query("SELECT kuk FROM gos WHERE strana='$a'"));
$kyk=$ky['kuk'];if(!empty($kyk)){
$sum = 25; // число записей на странице
$result = mysql_query("SELECT count(*) as a from gos where kuk='$kyk'");
$arr = mysql_fetch_row($result);$rec = $arr[0];
if(!isset($_GET['str'])){$str = 0;}else
{$str = $_GET['str'];}$start = $str * $sum;
$r = mysql_query("SELECT * FROM gos where kuk='$kyk' order by `id` desc LIMIT $start, $sum");
$n = mysql_num_rows($r);for ($i = 0; $i < $n; $i++){$m= mysql_fetch_array($r);
echo"$m[strana],";}}else{}
?>