|
|
Posted by Richard Lynch on 03/15/05 18:04
> 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
Navigation:
[Reply to this message]
|