,

echo "<table class='paginate sortable full'>";

 echo"<tr><th>No.</th><th>Brand</th><th>Model</th><th>Description</th><th>Price</th></tr>";

 $cari = $_GET['cari'];

 if ($cari == 'Search') {

 //langkah 1

 $batas = 5;

 $halaman = $_GET['halaman'];

 if (empty($halaman)) {

 $posisi = 0;

 $halaman = 1;

 } else {

 $halaman = ($halaman - 1) * $batas;

 }

 //langkah 2

 $jenis1 = $_GET['jenis1'];

 $jenis2 = $_GET['jenis2'];

 $jenis3 = $_GET['jenis3'];

 $jenis4 = $_GET['jenis4'];

 $jenis5 = $_GET['jenis5'];

 $jenis6 = $_GET['jenis6'];

 $model1 = $_GET['model1'];

 $model2 = $_GET['model2'];

 $model3 = $_GET['model3'];

 $model4 = $_GET['model4'];

 $model5 = $_GET['model5'];

 $model6 = $_GET['model6'];



 $tampil = mysql_query("SELECT k.nama_kat, det.model_no, det.deskripsi, (det.harga - (det.harga * d.discrate)) as diskount FROM anggota AS a

 INNER JOIN diskon AS d ON a.id_user = d.userid

 INNER JOIN kategori AS k ON d.brandname = k.id_kategori

 INNER JOIN diskon_det AS det ON k.id_kategori = det.nama_kategori

 WHERE

 k.id_kategori = '$jenis1' AND d.model_no LIKE '%$model1%' OR

 k.id_kategori = '$jenis2' AND d.model_no LIKE '%$model2%' OR

 k.id_kategori = '$jenis3' AND d.model_no LIKE '%$model3%' OR

 k.id_kategori = '$jenis4' AND d.model_no LIKE '%$model4%' OR

 k.id_kategori = '$jenis5' AND d.model_no LIKE '%$model5%' OR

 k.id_kategori = '$jenis6' AND d.model_no LIKE '%$model6%' AND a.username LIKE '%$user%'

 LIMIT $posisi, $batas");

 $jumlah = mysql_num_rows($tampil);



 if ($jumlah > 0) {

 

 $no = $posisi + 1;

 while ($data = mysql_fetch_array($tampil)) {

 echo "<tr>

 <td>$no</td>

 <td>$data[nama_kat]</td>

 <td>$data[model_no]</td>

 <td>$data[deskripsi]</td>

 <td>$data[diskount]</td>

 </tr>";

 $no++;

 }

 echo "</table>";



 //langkah 3



 $tampil2 = mysql_query("SELECT k.nama_kat, det.model_no, det.deskripsi, (det.harga - (det.harga * d.discrate)) as diskount FROM anggota AS a

 INNER JOIN diskon AS d ON a.id_user = d.userid

 INNER JOIN kategori AS k ON d.brandname = k.id_kategori

 INNER JOIN diskon_det AS det ON k.id_kategori = det.nama_kategori

 WHERE

 k.id_kategori = '$jenis1' AND d.model_no LIKE '%$model1%' OR

 k.id_kategori = '$jenis2' AND d.model_no LIKE '%$model2%' OR

 k.id_kategori = '$jenis3' AND d.model_no LIKE '%$model3%' OR

 k.id_kategori = '$jenis4' AND d.model_no LIKE '%$model4%' OR

 k.id_kategori = '$jenis5' AND d.model_no LIKE '%$model5%' OR

 k.id_kategori = '$jenis6' AND d.model_no LIKE '%$model6%'

 AND a.username LIKE '%$user%'");



 $jumlahData = mysql_num_rows($tampil2);

 $jmlHalaman = ceil($jumlahData / $batas);



 echo "Halaman : ";

 $file = "content.php";

 for($i = 0; $i <= $jmlHalaman; $i++){

 if($i != $halaman){

 echo"<a >$i</a>";

 } else {

 echo "<b>$i</b>";

 }

 }

 echo "<p align=center>Ditemukan <b>$jumlahData</b> Data</p>";

 }else{

 echo "Data yang anda cari tidak ada";

 }

 }

 echo "</table>";

yg di atas coding nya gan.. .
tapi knpa kok g mw tampil y gan???

dan 1 lagi yg ane bingung,,

[color=red]$file = "content.php";[/color]

 for($i = 0; $i <= $jmlHalaman; $i++){

 if($i != $halaman){

 echo"<a >$i</a>";

 } else {

 echo "<b>$i</b>";

 }

 }

yg ane warnain merah tuh gan,ane khan pke include
nah ini ane coding di file content.php sedangkan link di browser =

http://localhost/nama_web/e-pricing/media.php?module=home

lha trus yg bener var $file di isi apa gan

Mohon Bimbingan dan Pencerahannya Gan

Regards Newbie