Re: Infinite Loop Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Kyle Terry wrote:
I believe I'm doing everything right here. It just seems like it doesn't
end. The browser just keeps trying to load the page forever...

function displayAll(){
    global $db;
    $sql = "SELECT release_id, description, date(release_date) date, issues,
priority FROM release_data";

how many rows does this return?


    while($all->fetch()){

        $i = 0;
        $iss_link = explode(', ', $issues);
        foreach($iss_link as $a){
          $row2[$i] = "<a href=\"http://mantisus/view.php?id=$a\";
target=\"_blank\">".$a.'</a>';
          $i++;
        }

<snip>

You have a loop inside a loop. What makes it worse is that the loop is growing with every iteration.

If there are 100 rows, then at the end, there are 100 entries in the $issues array.

To get to that point, you are doing a loop of size "X" where "X" = the row number being processed. ie row "2" is doing a foreach over 2 entries. row 15 is doing a foreach over 15 entries. row 90 is doing a foreach over 90 entries.


--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux