Re: Infinite Loop Issue

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";

    $all = $db->prepare($sql);
    $all->execute();
    $all->bind_result($release_id, $description, $date, $issues, $priority);

    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++;
        }

In pseudo code you have: for each result from the db explode the issues add another issue to the list So: no issues at start row 1 fetched explodes issues adds another issue (1 issue) row 2 fetched explodes issues (now 1) add another issue (now 2) row 3 fetch explode issues (now 2) add another issue (now 3) and so on. So your list is getting longer and longer and you're adding to it for each row you get from the db. -- Postgresql & php tutorials http://www.designmagick.com/