View Single Post
  #1 (permalink)  
Old 08-19-08, 03:33 PM
snakeob snakeob is offline
Newbie Coder
 
Join Date: Jun 2008
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
multidimentional msql_fetch_array

PHP Code:

<?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($result4MYSQL_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>"
;
}}}
}
?>

nothing prints on my table what am i doin wrong??
Reply With Quote