[RESOLVED] Linking part of table

darko886

Hello, this is my php code that shows the whole mysql table in a html table

<html>
<?php 
$database="darko886_table"; 
mysql_connect ("supremecenter47.com", "darko886_table", "password"); 
@mysql_select_db($database) or die( "Unable to select database"); 
$result = mysql_query( "SELECT * FROM `stats` ORDER BY `pts` DESC, `gd` DESC, `gf` DESC" ) 
or die("SELECT Error: ".mysql_error()); 
$num_rows = mysql_num_rows($result); 
?>
<table border=1 bordercolor=black cellspacing=0> 
<tr bgcolor=b00004>

<td><B><font color=white>Player</B></td>
<td><b><font color=white>Club</b></td>
<td width="25"><b><font color=white>Pld</b></td>
<td width="25"><b><font color=white>W</b></td>
<td width="25"><b><font color=white>D</b></td>
<td width="25"><b><font color=white>L</b></td>
<td width="25"><b><font color=white>GF</b></td>
<td width="25"><b><font color=white>GA</b></td>
<td width="25"><b><font color=white>GD</b></td>
<td width="25"><b><font color=white>Pts</b></td>
</tr>
<?php
while ($get_info = mysql_fetch_row($result)){ 
echo "<tr>\n"; 
foreach ($get_info as $field) 
echo "\t<td><font face=arial size=1/>$field</font></td>\n"; 
echo "</tr>\n"; 
} 
echo "</table>\n"; 
?>

Now what I want it to do, is everything it gets from the column 'player' in the mysql database to link it. For example, for it to link it to like http://www.premierpes.com/player.php?player= and after the = to put the 'player'. So if one of the players is darko886 it would be player.php?player=darko886. How can I do that? To see that code in action goto www.premierpes.com/table.php

All of the player names under 'Player' i would like to be linked...

Thanks
Darko886

cgraz

Put this in your loop

print '<a href="/player.php?player=' . $get_info['player'] . '">' . $get_info['player'] . '</a>';

Weedpacket

echo "http://blablabla/thingy=".$playername;

darko886

I am sorry, I am pretty new at this... when you say put it in the loop where exactly do I need to put it?

Thanks
darko

bpat1434

<html>
<?php
	$database="myTable";
	mysql_connect ("******", "*******", "*******");
	@mysql_select_db($database) or die( "Unable to select database");
	$result = mysql_query( "SELECT * FROM `stats` ORDER BY `pts` DESC, `gd` DESC, `gf` DESC" )
	or die("SELECT Error: ".mysql_error());
	$num_rows = mysql_num_rows($result);
?>
<table border=1 bordercolor=black cellspacing=0>
	<tr bgcolor=b00004>
		<td><b><font color=white>Player</b></td>
		<td><b><font color=white>Club</b></td>
		<td width="25"><b><font color=white>Pld</b></td>
		<td width="25"><b><font color=white>W</b></td>
		<td width="25"><b><font color=white>D</b></td>
		<td width="25"><b><font color=white>L</b></td>
		<td width="25"><b><font color=white>GF</b></td>
		<td width="25"><b><font color=white>GA</b></td>
		<td width="25"><b><font color=white>GD</b></td>
		<td width="25"><b><font color=white>Pts</b></td>
	</tr>
<?php
while ($row = mysql_fetch_assoc($result)){
	echo '
	<tr>
		<td><a href="player.php?player='.$row['player'].'">'.$row['player'].'</a></td>
		<td>'.$row['club'].'</td>
		<td>'.$row['pld'].'</td>
		<td>'.$row['w'].'</td>
		<td>'.$row['d'].'</td>
		<td>'.$row['l'].'</td>
		<td>'.$row['gf'].'</td>
		<td>'.$row['ga'].'</td>
		<td>'.$row['gd'].'</td>
		<td>'.$row['pts'].'</td>
	</tr>';
}
echo '
</table>';
?>

Per our convo, that should get you what you need. you'll notice I modified the loop. If you don't understand something, please ask.

darko886

perfecto! thanks a lot!