Urgent! Link not passing variable!

Anon

This is a repost. I've got a couple of problems that I can't quite figure out.

First, the search result spits out the same individual spits out the same person 3-4 times each. I do have a "join" condition (clients.cusername = interests.cusername) but that hasn't solved my problem

Second, I want each persons name to be a link and pass their cusername to the next page. I have the following coding for this:
<a href=\"userprofile.php?CUserName=$row->CUserName\">$row->CFirstName $row->CLastName</a>
When you put your mouse over the link, it doesn't show username it is going to pass.

Anyway, here's my code below:
<?PHP
//query for matches
$query = "SELECT clients.cusername, CFirstName,CLastName,CEmail,CCity
FROM clients,interests
WHERE
((I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests')
OR (CCity LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CPicture LIKE '$C%%%'
OR CEyeColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CHairColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CKids LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CBody LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CEducation LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CChurch LIKE '$C%%%%%%%%%%%%%%%%%%%%%')
AND clients.CUserName = interests.CUserName)
ORDER BY CCity, CLastName
";

$answer = mysql_query($query);
$total_rows = mysql_num_rows($answer);
if($total_rows == 0)
print " Sorry! No profiles matched your search criteria ";
else
print "Found $total_rows profiles that matched your search criteria. ";

//Prints out the results of your query
print "<table border=1 cellpadding=5 cellspacing=0>";
print "<TR>";
print "<TD bgcolor=\"#dddddd\">#</td>";
print "<TD bgcolor=\"#dddddd\">Name</td>";
print "<TD bgcolor=\"#dddddd\">Email</td>";
print "<TD bgcolor=\"#dddddd\">City</td>";
print "<TD bgcolor=\"#dddddd\">
<a href=\"faqbuddylist\" target=\"new_window\">Buddy list</a>
</td>";
print "</tr>";

for ($loopvar=0; $loopvar<$total_rows; $loopvar++)
{
//This queries others with the same interests
$row = mysql_fetch_object($answer);
$tempvar = $loopvar+1;
print "<tr>";
print " <TD>$tempvar</td>
<TD><a href=\"userprofile.php?CUserName=$row->CUserName\">$row->CFirstName $row->CLastName</a></td>
<TD><a href=\"mailto:$row->CEmail\">$row->CEmail</a></td>
<TD>$row->CCity</td>
<TD>

<a href=\"buddyadded.php?CUserName=$row->CUserName\">Add to my buddy list</a>

</td>";
print "</tr>";
}
print "</table>";
print " ";
?>

neville

Your query needs to be like this

SELECT DISTINCT C.cusername,C.FirstName,C.LastName,C.Email,C.City FROM clients C,interests I WHERE...

the distinct may give you just one row

Your HREF:

try this

first switch to normal HTML mode after closing your PHP tag

<a href="buddyadded.php?CUserName='<? echo $row->CUserName'?>">Add to my buddy list</a>

now reopen your PHP tag

<?PHP

When passing a string thru href you need to enclose the string var with a '' ie:'$str_var'

I hope this helped

Ps: its a not a good idea to print HTML tags using PHP unless absolutely needed