Re: making links out of records? newbie

> Hi there, i have a page called squad.php which queries a mysql table and > outputs all the squad members from by football team. This is fine, > however i would like to make each returned record into a hyperlink which > when clicked on displays more details about that player. I believe i > need to use the $PHP_SELF command, how i do this though i do not know. > Here is what i have so far: > > <?php > // Connecting, selecting database > $link = mysql_connect('localhost', '', '') > or die('Could not connect: ' . mysql_error()); > echo 'Connected successfully'; > mysql_select_db('database') or die('Could not select database'); > > // Performing SQL query > $query = 'SELECT * FROM tblusers WHERE squadnum <99'; > $result = mysql_query($query) or die('Query failed: ' . mysql_error()); > > // Printing results in HTML > echo "<table border=1>\n"; > while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { > echo "\t<tr>\n"; $id = $row['id']; > foreach ($row as $col_value) { echo "\t\t<td><a href=squad_member.php?id=$id>$col_value</a></td>\n"; > } > echo "\t</tr>\n"; > } > echo "</table>\n"; > > ?> > > Any help much appreciated, nick. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Like Music? http://l-i-e.com/artists.htm