<?php $query = mysql_query("SELECT * FROM biller"); while ($result = mysql_fetch_array($query)) { $query2 = mysql_query("SELECT * FROM biller WHERE account LIKE ($_POST[number])"); while ($result2 = mysql_fetch_array($query2)) { $query3 = mysql_query("SELECT * FROM biller WHERE calldate LIKE '%($_POST[month])%'"); while ($result3 = mysql_fetch_array($query3)) { $query4 = mysql_query("SELECT * FROM biller WHERE calldate LIKE '%($_POST[year])%'"); while ($row = mysql_fetch_array($result4, MYSQL_ASSOC)) { $account=$row['account']; $calldend=$row['calldateend']; $calldstart=$row['calldatestart']; $calldate=$row['calldate']; $totalctime=$row['totalcalltime']; $totalccharge=$row['totalcallcharge']; $charge=$row['charge']; $origin=$row['origin']; $navi=$row['navigataid']; print "<tr> <td>$account</td> <td>$calldend</td> <td>$calldstart</td> <td>$calldate</td> <td>$totalctime</td> <td>$totalccharge</td> <td>$charge</td> <td>$origin</td> <td>$navi</td> </tr>"; }}} } ?>