Jump to content


This topic is now archived and is closed to further replies.


search help

Recommended Posts

I have a simple search, where users can query on a players last name, but I want to add something to the search results.


Right now it displays, the player with a link to his profile, but I want to add the team name after...Like this:


Player Name, Team Name



Heres the meat of my results page:


[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]if ($lname == \"\")

{$lname = \'%\';}




$result = mysql_query (\"SELECT fname, lname, player_id

            FROM players

                        WHERE lname LIKE \'%$lname%\'



echo \"<table align=\\"center\\" width=\\"55%\\" border=\\"1\\" cellpadding=\\"2\\"



  echo \"<TR align=\\"center\\"><td><b>Players found:     </b> </td></tr>\";


if ($row = mysql_fetch_array($result)) {

        $fname = $row[\'fname\'];

    $player_id = $row[\'player_id\'];

    $nflteamname = $row[\'nflteam_name\'];

do {

print \"<TR><TD> <a href=\'/football/players.php?player_id=\" . $player_id . \"\'> \".$fname.\"



} while($row = mysql_fetch_array($result));

} else {print \"Sorry, no records were found!\";}

print \"</table>\";





This is the query for the NFL team name, but I'm just having trouble working it in...



SELECT players.nflteams_id, nflteam_name, player_id

FROM players, nflteams

WHERE nflteams.nflteam_id = players.nflteam_id



If you want to try it out....search for the name "Kennison" here



Another problem I'm having is if you query for a common name such as smith. It returns only the first occurence of Smith, but multiple times.

Share this post

Link to post
Share on other sites

Make your initial query :


[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] p.fname, p.lname, p.player_id, t.nflteam_name

FROM players p INNER JOIN nflteams t

ON p.nflteam_id = t.nflteam_id

WHERE lname LIKE '%$lname%' [!--sql2--][/div][!--sql3--]

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.