Could anyone tell me why it do not work with this - supposed to make a two level combination à la this (sorry, but "art" here is Danish for sort!):

portalart1
portalA
portalB
portalart2
portalC
portalart3
portalD
portalE

$result = mysql_query(" SELECT
a.portalart, a.portalart_nr, p.portaladresse_art, p.portaladresse_navn, p.portaladresse_url
FROM portalart AS a, portaladresser AS p
WHERE p.portaladresse_art = a.portalart_nr
ORDER by a.portalart_nr ASC ");

while ( $row = mysql_fetch_row($result) )
{
            echo "<tr>";
            echo "<td align=\"center\">";
            echo "<b>Portalart: " . $row['0'] . "</b>";
            echo "</td>";
            echo "</tr>";

            echo "<tr>";
            echo "<td align=\"left\">";
            echo "URL og navn: <a href=\"" . $row['4'] . "\">" . $row['3'] . "</a>";
            echo "</td>";
            echo "</tr>";
}

//tb portalart: id, portalart, portalart_nr
//tb portaladresser: id, portaladresse_art, portaladresse_navn, portaladresse_url

The result is Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource - regarding while...

I have three things to say to you:

1) It is ALWAYS a good idea to test for errors:
mysql_query('text') or die('error in query: '.mysql_error());

2) Why is your Warning about mysql_fetch_array() when you're using mysql_fetch_row()?

3) This topic really doesn't belong in the Feedback area.

HTH!

-Snib <><
Try new FreshView 0.2!
There are only two stupid questions: the one you don't ask, and the one you ask more than once ;)

Sorry for wrong forum - and too quick questioning.

I have found the solution as this one (and mysql_fetch_array and mysql_fetch_row are both ok):

$result = mysql_query(" SELECT
a.portalart, p.portaladresse_navn, p.portaladresse_url
FROM portalart AS a, portaladresser AS p
WHERE p.portaladresse_art = a.portalart_nr
ORDER by a.portalart_nr ASC ") or die(mysql_error());

$gammelportal = '';
while ( $row = mysql_fetch_array($result) )
{
    if( $gammelportal != $row[0] )
    {
            $gammelportal = $row[0];
            echo "<tr>";
            echo "<td align=\"center\">";
            echo "<b>Portalart: " . $row['0'] . "</b>";
            echo "</td>";
            echo "</tr>";
    }
            echo "<tr>";
            echo "<td align=\"left\">";
            echo "URL og navn: <a href=\"" . $row['2'] . "\">" . $row['1'] . "</a>";
            echo "</td>";
            echo "</tr>";
}