tes scrript

 <?php
         include 'koneksi.php';


					if (isset($_POST['tcari'])) {

					$from = $_POST["dp1"];
					$to = $_POST["dp2"];


					// maksudnya koding di bawah ini harusnya di taruh disini / di atas isset tcari
					$per_page=10;
					$total_querytime=0;

					$page=isset($_GET['p'])?(int)$_GET['p']:1;
					if($page<1) $page=1;
					$offset=($page-1)*$per_page;

					$starttime=microtime();
					// yang atas

                    $query = "SELECT * from log_transaksi where tanggal >= DATE_FORMAT('" . $from . "', '%Y-%m-%d') AND tanggal <=  DATE_FORMAT('" . $to . "', '%Y-%m-%d') AND agenid ='$agenid' ORDER BY tanggal,jam ASC ";
                    $exe = mysql_query($query);
                    $no = 1;
					$baru = "#FFFF00";
					$lama="#FFFF00";
                    while($row = mysql_fetch_assoc($exe)){

                        $a = $row['tanggal'];
                        $b = $row['jam'];
                        $c = $row['agenid'];
                        $d = $row['denom'];
                        $e = $row['nomor'];
						$f = $row['harga'];
                        $g = $row['status'];
						$h = $row['vsn'];


					// beri warna selang seling
					if(($no % 2)==0)$warna = $baru;

					else $warna = $lama;


                    echo "<tr bgcolor=$warna  align=center>
					<td>$no</td>
					<td>$a<br>$b</td>
					<td>$c</td>
					<td bgcolor=blue>$d<br>$f</td>
					<td>$e</td>
					<td>$g</td>
					<td>$h</td>
					</tr>";
                    $no++;


                    }}
					?>