I've searched the posts, and none seems like quite what I'm doing (I guess that's why they're not working for me, either).
This is the code:
<?php
// Retrieve data from table here
$result = @("SELECT DISTINCT Category FROM Library");
if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}
// Display the content of each row in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<p>" . $row["Category"] . "</p>");
}
?>
I am looking to have the row Category turn into its own hyperlink, Category --> <a href ="/Category/>Category</a>
Is there a dynamic version, or should I just place the hyperlink code in the DB row?