How to print database content.

Do you want to print the hyperlinks, or the pages at the URLs of the hyperlinks?

I only want to print the hyperlinks.

This line is either trying to fetch a website from a given URL, or trying to fetch the contents of a given filename:

$input = @file_get_contents($text) or die("Kunde inte läsa: $kategori - $titel");

Select allOpen in new window

As Ray says, we need to have a better understanding of what kind of data you're dealing with. I'd like to see the output of:

print "Text: '$text'<br>\n"; 

Select allOpen in new window

Run this just before the file_get_contents.

I added echo "<tr><td>$text</td></tr><tr><td>--- --- ---</td></tr>";
Got all the pages in the database I wanted. So far so good.
I took the code of the html page created and attached it to the "Attach file". Please see the file 'page.txt'.

-------------------------------------------

This might be irrelevant, however, when running the file without this added command (echo "<tr><td>$text</td></tr><tr><td>--- --- ---</td></tr>";) , I get the message "Kunde inte läsa: $kategori - $titel" comming from "$input = @file_get_contents($text) or die("Kunde inte läsa: $kategori - $titel");"
That's the reason I asked if you think this command is wrong.
page.txt

TerryAtOpus and Ray_Passeur, thanks for your replies.
With your help I managed to get the output I want:

<?php
//error_reporting(E_ALL|E_STRICT);
//ini_set('display_errors', '1');
date_default_timezone_set('Europe/Paris');
include "../dbconfig/dbconfig.php";

@mysql_connect($host,$usr,$pwd)
or die("<p>Kan ej ansluta till databasservern.</p>");
@mysql_select_db($db)
or die("<p>Kan ej ansluta till databasen " . $db . ".</p>");
$nr = 0;
$SQL = " SELECT text, kategori, titel, sida FROM jbs ";
$retid = mysql_query($SQL);
if (!$retid) { echo( mysql_error()); }
            else {


    $numrows = mysql_numrows($retid);
    $backcolour = "FFFFFF";
    for ($i=0; $i <$numrows; $i  )
    {
        $rs = mysql_fetch_array($retid);
        if ($backcolour == "FFFFFF")
            {
            $backcolour = "e8e8e8";
            }
        else
            {
            $backcolour = "FFFFFF";
            }

            while ($row = mysql_fetch_array($retid)) {
            $text = $row["text"];
            $kategori = $row["kategori"];
            $titel = $row["titel"];
            $sida = $row["sida"];
$nr++;
$regexp = "/<a\s[^>]*href=(\"??)([^\" >]*?)\\1[^>]*>(.*)<\/a>/";

if (preg_match("$regexp", "$text")) {
  echo "<tr><td>&nbsp;</td><td bgcolor=\"$backcolour\">$nr</td><td bgcolor=\"$backcolour\">&nbsp;</td><td bgcolor=\"$backcolour\"><strong>$kategori - $titel:</strong> <a href=\"http://www.jbs.nu/$sida\" target=\"_blank\" >$sida </a></td><td>&nbsp;</td></tr>
        <tr><td>&nbsp;</td></tr>";
}}}}
?>

This code takes ages to finish. Any suggestions on how to speed it up?

How many rows of data are you working with, and what's the typical size of each value in the text column?

There are in all 93 rows of data. To give you an understanding of the size of each value I attach a file.
jbs-tabell.csv

Making the wildcards non-greedy may help a little:
$regexp = "/<a\s[^>]*?href=(\"??)([^\" >]*?)\\1[^>]*>(.*?)<\/a>/";

Also, if you want to print just the link (and not the text that is linked), then this should suffice:
$regexp = "/<a\s[^>]*?href=(\"??)([^\" >]*?)\\1[^>]*>/";

Thanks for the points and thanks for using EE, ~Ray