Need help with making a variable link

[Eminem]

Well, I'm new to PHP. I decided to make something that finds users on my SMF forum by connecting to the database. Now, I want to make the results links to their profiles on SMF.

 

I'd assume I should use this code:

 

<a href="', $scripturl, '?action=profile;u=', $member['id'], '"></a>

 

And here is my whole file:

 

<?php

$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM smf_members");

while($row = mysql_fetch_array($result))

{

$a[]= $row['realName'];

}

mysql_close($con);

$q=$_GET["q"];

if (strlen($q) > 0)
{
$hint="";
for($i=0; $i<count($a); $i++)
  {
  if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
    {
    if ($hint=="")
      {
      $hint=$a[$i];
      }
    else
      {
      $hint=$hint." <BR> ".$a[$i];
      }
    }
  }
}

if ($hint == "")
{
$response="No members with the text specified.";
}
else
{
$response=$hint;
}

echo $response;
?>

 

Here is the search itself.

 

As I said earlier, I want to make the results link to their profile. Any help?

[Caesar]

<?php

echo'<a href="'.$url.'?action=profile&u='.$member['id'].'">Click Me</a>';

?>

[Eminem]

<?php

echo'<a href="'.$url.'?action=profile&u='.$member['id'].'">Click Me</a>';

?>

 

How would I go about placing that into the code I gave?

[thefortrees]

Just put it in outside of one of the if statements

[Eminem]

Just put it in outside of one of the if statements

 

I want $row['realName'] to link to its profile. How would do that?