<div align="center">
<table width="906" height="158" border="1">
<form id="form1" name="form1 method="get" action="list.php">
<tr>
<th scope="col">ID</th>
<th scope="col">DATE</th>
<th scope="col">IP</th>
<th scope="col">BROWSER</th>
<th scope="col">REF</th>
<th scope="col">CITY</th>
</tr>
<?php
include 'mysqlcon.php';
$siralama = $_GET['siralama'];
$sutun = $_GET['sutun'];
if ($sutun == "id"){
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE id='$siralama'"));
}else if ($sutun == "ip") {
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE ip='$siralama'"));
} else if ($sutun == "date") {
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE date='$siralama'"));
} else if ($sutun == "browser") {
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE browser='$siralama'"));
} else if ($sutun == "ref") {
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE ref='$siralama'"));
} else if ($sutun == "city") {
$sorgu=mysql_fetch_assoc(mysql_query("SELECT * FROM ip WHERE city='$siralama'"));
} else if ($sutun == NULL) {
$sorgu = mysql_query("SELECT * FROM `ip` ORDER BY id"); }
while ($islem = mysql_fetch_array($sorgu)) { // while ile her bir satir icin islem yapmaya baslayalim
echo "
<tr>
<td><a href=\"list.php?siralama={$islem['id']}&sutun=id\"> {$islem['id']} </a></td>
<td><a href=\"list.php?siralama={$islem['date']}&sutun=date\"> {$islem['date']} </a></td>
<td><a href=\"list.php?siralama={$islem['ip']}&sutun=ip\"> {$islem['ip']} </a></td>
<td><a href=\"list.php?siralama={$islem['browser']}&sutun=browser\"> {$islem['browser']} </a></td>
<td><a href=\"list.php?siralama={$islem['ref']}&sutun=ref\"> {$islem['ref']} </a></td>
<td><a href=\"list.php?siralama={$islem['city']}&sutun=city\"> {$islem['city']} </a></td>
</tr>
";
}
echo "</form></table></div>";
?>şöyle bir kod yazdım ama
Warning: mysql_fetch_array() expects parameter 1 to be resource, array given in /htdocs/list.php on line 35
dedi bunu çözemedim bir türlü uğraşıyorum sağolun desteğiniz için.
Edit = kodu düzelttim şuan sapa sağlam çalışıyor.
<div align="center">
<table width="906" height="158" border="1">
<form id="form1" name="form1 method="get" action="list.php">
<tr>
<th scope="col">ID</th>
<th scope="col">DATE</th>
<th scope="col">IP</th>
<th scope="col">BROWSER</th>
<th scope="col">REF</th>
<th scope="col">CITY</th>
</tr>
<?php
include 'mysqlcon.php';
$siralama = $_GET['siralama'];
$sutun = $_GET['sutun'];
if ($sutun == "id"){
$sorgu=mysql_query("SELECT * FROM ip WHERE id='$siralama'");
}else if ($sutun == "ip") {
$sorgu=mysql_query("SELECT * FROM ip WHERE ip='$siralama'");
} else if ($sutun == "date") {
$sorgu=mysql_query("SELECT * FROM ip WHERE date='$siralama'");
} else if ($sutun == "browser") {
$sorgu=mysql_query("SELECT * FROM ip WHERE browser='$siralama'");
} else if ($sutun == "ref") {
$sorgu=mysql_query("SELECT * FROM ip WHERE ref='$siralama'");
} else if ($sutun == "city") {
$sorgu=mysql_query("SELECT * FROM ip WHERE city='$siralama'");
} else if ($sutun == NULL) {
$sorgu = mysql_query("SELECT * FROM `ip` ORDER BY id"); }
while ($islem = mysql_fetch_array($sorgu)) { // while ile her bir satir icin islem yapmaya baslayalim
echo "
<tr>
<td><a href=\"list.php?siralama={$islem['id']}&sutun=id\"> {$islem['id']} </a></td>
<td><a href=\"list.php?siralama={$islem['date']}&sutun=date\"> {$islem['date']} </a></td>
<td><a href=\"list.php?siralama={$islem['ip']}&sutun=ip\"> {$islem['ip']} </a></td>
<td><a href=\"list.php?siralama={$islem['browser']}&sutun=browser\"> {$islem['browser']} </a></td>
<td><a href=\"list.php?siralama={$islem['ref']}&sutun=ref\"> {$islem['ref']} </a></td>
<td><a href=\"list.php?siralama={$islem['city']}&sutun=city\"> {$islem['city']} </a></td>
</tr>
";
}
echo "</form></table></div>";
?>