How do I put a http Link inside a PHP code?

Posted: Wed Jan 19, 2005 7:34 pm (19 years, 3 months ago)

Hello people,

I'm a NewB 2 PHP. Can anyone help me with this:

I have created a simple DB table using PostgreSQL with values in the table.

My PHP code to retrieve data is:

<?PHP
echo " <left>CONNECTION MESSAGES ";
echo "<ul>";
echo "<li>establishing connection with database</li>";
$conn = pg_Connect ("port=5432 dbname=abu user=ma401ak");
if (!$conn) {
echo "<li>connection to database failed</li>"
; exit; }
$result = pg_exec ($conn, "SELECT DISTINCT name
FROM staff
ORDER BY name");

if (!$result) {
echo "<li>an error has occured in getting data from
database</li>";
exit;}
echo "<li>connection to database ok</li>" ;
echo " </left></ul><hr>";
echo "LIST OF STAFF <ol>";
for ($row = 0; $row < pg_numrows($result); $row++) {
$tuple = pg_fetch_array($result, $row);
echo "<li>" . $tuple["name"] . "</li>";

}
pg_Close($conn);
echo "</ul><hr>";
?>

Output looks like this:

CONNECTION MESSAGES

. establishing connection with database
. connection to database ok

--------------------------------------------------------------------------------
LIST OF STAFF

1. Dr What Ever
2. Dr Joe Blogs

Here what I can't do:

I want each staff to have an actual website link next to there name. So lets say:

1. Dr What Ever Vist My Home Page

Visit My home page should be a website link... Also is it possible have a BUTTON i.e: 'Visit My Home Page' as a button rather than just a link.

Both the button & Link solution will be most appreciated.

Thanks a Million