Any Error In this Code...??..browser taking infinite time to refresh this..

[murli800]

<table >

        <tr>

            <td>Department Id</td>

            <td>Department Name</td>

            <td>Status</td>

 

        </tr>

        <tr>

        <?php while($dep = mysql_fetch_assoc(mysql_query("SELECT * FROM department"))){foreach($dep as $value)

        {?>

       

            <td><?php echo $value;?></td>

           

       

        <?php }}?>

            </tr>

 

    </table>

[Pikachu2000]

Don't nest all the mysql_* functions; it makes debugging a query next to impossible. The way you have it above, I don't believe it even works at all.

 

$query = "SELECT whatever FROM table";
$result = mysql_query($query);
while $array = mysql_fetch_assoc($result) ) {
     // etc.
}

[The Little Guy]

every time it comes to the while loop, won't it execute the query again the way he has it, and if there is at least one result it will go back to the start of the while loop again. correct?

[jcbones]

Oh, it will work, returning the same row in an infinite loop. Causing the script to timeout, which is why it "takes forever".

[Pikachu2000]

Oh, it will work, returning the same row in an infinite loop. Causing the script to timeout, which is why it "takes forever".

 

Not exactly what I meant by "works" . . .

[murli800]

thanx..topic solved