Argh, in the below code it would seem that the first while loop is only executing once, despite the query returning two results, and I cannot for the life of me work out why. GRRR
Any help appreciated

PHP Code:

$query = "SELECT sectid, name, type, description FROM ".$prefix."_sections;";
$results = mysql_query($query);
while($rows = mysql_fetch_row($results)) {
    $sectid = $rows[0];
    $sectname = $rows[1];
    $secttype = $rows[2];
    $sectdescript = $rows[3];
    echo "<li>$sectname</li>\n";
    echo "<ul>\n";
    $query = "SELECT forid, name, type, description FROM ".$prefix."_forums WHERE sectid = $sectid";
        $results = mysql_query($query);
        while($rows = mysql_fetch_row($results)) {
            $forid = $rows[0];
            $forname = $rows[1];
            $fortype = $rows[2];
            $fordescript = $rows[3];
            echo "<li><a href='$page?forum=$forid'>$forname</a></li>\n";
        }
        echo "</ul>\n";
} 


I thinkit might be the semi-colon on the query string line - should be....

PHP Code:

$query = "SELECT sectid, name, type, description FROM ".$prefix."_sections"; 


Might work......

Stoot

thanks, but that seems to make no difference

I think its the second database query, you are overwriting the $results variable that was created from the first query so when you do mysql_fetch_row at the start of the first while loop it doesnt have anymore...

Hope that makes sense.
Stoot

Don't convert your long vars to short. By assigning them to vars your contradicting the purpose of the loop. I've illustrated below...

PHP Code:

$row_results = mysql_fetch_assoc($results);

while($row_results = mysql_fetch_assoc($results)) {
    echo "<li>$row_results['columnName']</li>\n";
    echo "<ul>\n";
    $query = "SELECT forid, name, type, description FROM ".$prefix."_forums WHERE sectid = $sectid";
        $results = mysql_query($query);
        while($row_results = mysql_fetch_assoc($results)) {
          echo "<li><a href='$page?forum=$row_results['columnName']'>$row_results['columnName']</a></li>\n";
        }
        echo "</ul>\n";
}