hyperlink output from db

[Anon]

I'm driving myself crazy trying to make this work -- I want to have the Web Page column, the last one in the table as myrow url, as a hyperlink but just can't get it ... help please if possible.
This is the script
......

?> </p><p> <?php
if ($myrow = mysql_fetch_array($result)) {

echo "<table border=0>\n";
echo "<tr><td>Company:</td><td>Area:</td><td>Phone:</td><td>Web page:</td></tr>\n";
do {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</tr>\n", $myrow["company"], $myrow["suburb"], $myrow["phone"], $myrow ["url"]);

} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry, no records were found for $tariff but such lodgings probably exist. We can only store published information.";
}

// Release the Result Set
mysql_free_result($result);

// Close the connection
mysql_close($db);

?>
..........

[Anon]

Try this print line:

print('<tr><td>'.$myrow['company'].
'</td><td>'.$myrow['suburb'].
'</td><td>'.$myrow['phone'].
'</td><td><a href="'.$myrow['url'].'">'.$myrow['url'].
'</a></td></tr>
';

[Anon]

Thanks Grumbler but that didn't work either - a parse error apparently
regards
Russell

[Anon]

What I wrote is missing a ) from the end.
I usually use echo anyway, and tend to leave the parentheses out in that case; I just forgot I wasn't doing that this time 🙂