I have a column in my database that stores the top gaining athletes on my fantasy sports website. I want to make each athlete's name a clickable link that directs users to their individual page on our site. Currently, the function in the code is calling the athlete's name as "companyname". Is there a way to turn this into a clickable link within the table? Should I create another function for generating URLs or add a new column for storing them? I'm concerned that the database may only display the URL text without making it an actual hyperlink. Can anyone advise on how to achieve this?
Below is the list of Top Gaining Athletes Today:
- Jamaal Charles - 0.54%
- Kyle Rudolph - 0.50%
- A.J. Green - 0.48%
- Michael Bush - 0.48%
- Jared Cook - 0.47%
- Christian Ponder - 0.45%
- Alfred Morris - 0.45%
- Nate Washington - 0.44%
- Ryan Succop - 0.44%
- DeMarco Murray - 0.43%
function getTopAthletes($connection){
$i=1;
$query = "SELECT b.companyname, (a.currentprice - a.open)/a.open as performance FROM jm_market a, jm_stocks b WHERE a.symbol = b.symbol AND active = 'Y' ORDER BY performance desc LIMIT 10";
$result=mysql_query($query,$connection) or die('Problem with obtaining top PLAYERS: ' . $query);
$output = "<table class='tab1 bborder' cellspacing='0'>";
$output.= "<th colspan='4'>Top Gaining Athletes Today</th>";
while($row=mysql_fetch_array($result)){
// Shorten really long names
if (strlen($row['companyname']) > 20) {
$short = explode (' ', $row['companyname']);
$row['companyname'] = substr( $short[0],0,1 ) . ". ";
unset($short[0]);
foreach ($short as $n) {
$row['companyname'] .= $n . " ";
}
$row['companyname'] = rtrim($row['companyname']);
}
$output .= "<tr ><td width='20px'><strong>" . $i.".</strong></td>";
$output .= "<td ><strong><a href='" . $row['companyname']."-profile.html'>" . $row['companyname']."</a></strong></td>";
$output .= "<td><strong>" . number_format(($row['performance']) * 100,2)." %</strong></td></tr>";
$i++;
}
$output .= "</table>";
return $output;
}