Öncelikle cevabınız için çok teşekkürler.
Ama malesef sonuç alamadım
Boş sonuç döndürüyor.
Nerde hata yapıyorum bilmiyorum.
Kodlarım aşağıda :
<html>
<head>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<link rel="stylesheet" type="text/css" href="images/style.css" />
</head>
<?php
$arama = $_POST['arama'];
if(empty($arama)){
echo("<center><b>Arama Kutusunu Boş Bıraktınız. Lütfen Geri Dönüp Doldurunuz.</b></center>");
}else{
include "database.php";
$sayfa = $_GET['sayfa'] ? $_GET['sayfa'] : 0;
$sayfabasi=30;
$sorgu=mysql_query("SELECT * FROM 'depo' WHERE 'zaman' BETWEEN '{$zaman1}' AND '{$zaman2}' (
`id` LIKE '%$arama%'
OR `zaman` LIKE '%$arama%'
)");
$toplam=mysql_num_rows($sorgu);
$kacsayfa=ceil($toplam/$sayfabasi);
$basla=$sayfa*$sayfabasi;
echo"<table border=\"1\" width=\"870\" cellspacing=\"0\" cellpadding=\"0\" height=\"63\">";
echo"<tr><td width=\"20\" height=\"30\" align=\"center\">";
echo"<font face=\"Agency FB\">No</font></td><td width=\"120\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Resim</font></td><td width=\"150\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Malzeme Adı</font></td>";
echo"<td width=\"70\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Malzeme Kodu</font></td><td width=\"100\" height=\"30\" align=\"center\">";
echo"<font face=\"Agency FB\">Kategori</font></td><td width=\"80\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Stok Miktarı</font></td>";
echo"<td width=\"100\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Kayıt'ı Yapan Personel</font></td>";
echo"<td width=\"50\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Birim Fiyat</font></td><td width=\"50\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Kdv</font></td><td width=\"50\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Toplam Fiyat</font></td><td width=\"80\" height=\"30\" align=\"center\"><font face=\"Agency FB\">Seçenekler</font></td></tr>";
$bilgi = mysql_query("SELECT * FROM 'depo' WHERE 'zaman' BETWEEN '{$zaman1}' AND '{$zaman2}' (
`id` LIKE '%$arama%'
OR `zaman` LIKE '%$arama%'
) limit $basla, $sayfabasi");
if($bilgi)
{
while($satir = mysql_fetch_array($bilgi))
{
$mesaj = $satir['mesaj'];
echo"<tr><td width=\"20\" height=\"30\">$satir[id]</td>";
echo"<td width=\"120\" height=\"30\"><a href=\"$satir[resim]\" target=\"_blank\"><img src=\"$satir[resim]\" width=\"75px\" border=\"0\"></a></td>";
echo"<td width=\"150\" height=\"30\">$satir[urunadi]</td>";
echo"<td width=\"70\" height=\"30\">$satir[malzemekodu]</td><td width=\"100\" height=\"30\">$satir[urunkategorisi]</td>";
echo"<td width=\"80\" height=\"30\">$satir[miktar] $satir[birim]</td><td width=\"100\" height=\"30\">$satir[personel]</td>";
echo"<td width=\"50\" height=\"30\">$satir[birimfiyat] $satir[fiyatbirimi]</td>";
echo"<td width=\"50\" height=\"30\">$satir[kdv] $satir[fiyatbirimi]</td>";
echo"<td width=\"50\" height=\"30\">$satir[toplamfiyat] $satir[fiyatbirimi]</td>";
echo"<td width=\"80\" height=\"30\"><a href=\"guncelle.php?id=$satir[id]\"><img src=\"images/edit.png\" border=\"0\" alt=\"Düzenle\"></a> <a href=\"sil.php?id=$satir[id]\"><img src=\"images/sil.png\" border=\"0\" alt=\"Sil\"></a> <a href=\"stok-azalt-tamamla.php?id=$satir[id]\"><img src=\"images/stok-.png\" border=\"0\" alt=\"Stok Azalt\"></a> <a href=\"stok-yukselt-tamamla.php?id=$satir[id]\"><img src=\"images/stok+.png\" border=\"0\" alt=\"Stok Yükselt\"></a></td></tr>";
}
}
echo"</table>";
for ($i=0;$i<$kacsayfa;$i++) {
if ($sayfa == $i)
echo "[<b>".$i."</b>]";
else
echo "<a href=arama.php?sayfa=".$i.">".$i."</a>";
}
}
echo"</center>";
?>
<tr>
<td width="120" align="center">
<form name="arama" id="arama" action="arama1.php" method="post">
Tarih 1:<input name="zaman" type="text" size="15" />
Tarih 2:<input name="zaman" type="text" size="15" />
<input name="button" class="arama" type="submit" value="">
</form>
</td>
</tr>
<?php
if (isset($_REQUEST["kullanici"])) {
include("database.php");
$sql = ("select * from uye");
}
else {
header ("Location: uyari.html");
}
?>Bir yardım lütfen
