Hyperlink on a printed set of data

dicky

That title has probably got you confused already!

I have printed the contents of a mySQL table onto www.fourmarksfc.co.uk\squads_1st_res.php and I would like to be able to click on the name and it bring up a player profile window like it used to on the old site (www.fourmarksfc.co.uk/oldsite/squads/squads_1sts_res.htm).

Do I simply add the <a> tag info within the name column in the database?

Ideally I would like to be able to HOVER over the name and it display the profile....I know I can do this using CSS but I will still need to use the <a> tag.

Cheers in advance.

Dicky

Houdini

You would just echo out the info as

echo "<a href='whateverhere'>What you want them to click Here!</a>";

dicky

Thanks - could you elaborate on that please....what would I have to change from what I have now?

<?php
                    $conn = @mysql_connect( "$dbHostname", "$dbUsername", "$dbPassword" )
                    or die( "Could not connect" );
                    $rs = @mysql_select_db( "fourmarks1", $conn )
                    or die( "Could not select database" );
                    $sql = "select * from players order by name";
                    $rs = mysql_query( $sql, $conn )
                    or die( "Could not execute query" );

                $list = "<table style=\"width:520px\" cellpadding=\"2\">";
                $list .= "<tr><th>Name</th>";
                $list .= "<th>Pos.</th>";
                $list .= "<th><img border=\"0\" src=\"Images/app1.jpg\" alt=\"Apps\">(L)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/app1.jpg\" alt=\"Apps\">(C)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/app1.jpg\" alt=\"Apps\">(=)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/goals.gif\" alt=\"Goals\">(L)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/goals.gif\" alt=\"Goals\">(C)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/goals.gif\" alt=\"Goals\">(=)</th>";
                $list .= "<th><img border=\"0\" src=\"Images/yellow.gif\" alt=\"Yellow\"></th>";
                $list .= "<th><img border=\"0\" src=\"Images/red.gif\" alt=\"Red\"></th>";
                while( $row = mysql_fetch_array( $rs ) )
                {
                $list .= "<tr>";
                $list .= "<td>".$row["name"]."</td>";
                $list .= "<td>".$row["position"]."</td>";
                $list .= "<td>".$row["1st_app_l"]."/".$row["res_app_l"]."</td>";
                $list .= "<td>".$row["1st_app_c"]."/".$row["res_app_c"]."</td>";
                $list .= "<td>".$row["1st_app_t"]."/".$row["res_app_t"]."</td>";
                $list .= "<td>".$row["1st_goals_l"]."/".$row["res_goals_l"]."</td>";
                $list .= "<td>".$row["1st_goals_c"]."/".$row["res_goals_c"]."</td>";
                $list .= "<td>".$row["1st_goals_t"]."/".$row["res_goals_t"]."</td>";
                $list .= "<td>".$row["1st_yellow"]."/".$row["res_yellow"]."</td>";
                $list .= "<td>".$row["1st_red"]."/".$row["res_red"]."</td>";
                $list .= "</tr>";
                }
                $list .= "</table>";
                echo( $list );
           ?>

Remember its the Name values that I want to have as a hyperlink.

Cheers 😉

Houdini

What are these names going to link to would it be a page with name.php each being different? or what? This is the line that needs the link applied to it, correct?

$list .= "<td>".$row["name"]."</td>";

dicky

Houdini wrote:
What are these names going to link to would it be a page with name.php each being different? or what? This is the line that needs the link applied to it, correct?
$list .= "<td>".$row["name"]."</td>"; 

Yes - either linking to a *.php page or having a hover feature so a window appears (using CSS like http://www.wickham43.supanet.com/tutorial/hoverpopups.html).

And yes, that is the line that needs to have the link applied to it.

Thanks.

Houdini

OK so if I get this right then you would want to make a link of the individual name and if clicked it would go to a page with information about that name. So you will then have a page like george.php and mike.php and so on that would have all their particular information on it right. Then what I would do is this to make it easier.

$name=$row['name'];
$list .= "<tr>";
$list .= "<td><a href='$name.php'>".$row["name"]."</a></td>";

dicky

Houdini wrote:
OK so if I get this right then you would want to make a link of the individual name and if clicked it would go to a page with information about that name. So you will then have a page like george.php and mike.php and so on that would have all their particular information on it right. Then what I would do is this to make it easier.
$name=$row['name'];
$list .= "<tr>";
$list .= "<td><a href='$name.php'>".$row["name"]."</a></td>";

Aha, I see.....I can understand how that would work so I'll try putting it into action this evening when I get home from work. So if the name in the database was "Fred Bloggs" the page it would refer to would have to be "Fred Bloggs.php" rather than "Fred_Bloggs.php"?

dicky

That works a treat - thanks!