Where's Waldo...PHP style

Anon

I've attached the coding below. Basically, the links don't pass variables. The applicable lines are surrounded by ########.
I'm completely stumped. Can you find the error?

<?PHP
session_start();
include("dblib.inc");
include("dynamicmenu.inc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<head>
<title>Search results</title>
<Link href="arial.css" rel=stylesheet title=arial type=text/css>

<body>
 
<img src="pics/logo.gif"> 
 
<a href="search.php">Search again</a>
 
<a href="memberprofile.php?<?=$PHPSESSID; ?>">Back to home</a>
 
 
<table width="640" cellpadding="0" cellspacing="0">
<TR>
<TD><?PHP include ("navigation.inc"); ?></td>
<TD>
<?PHP
//query for matches
if (CCity == "CNone")
{
//Use this query when city NOT specified
$query = "SELECT CFirstName, CLastName, CCity, CEmail, CID
FROM clients, interests
WHERE (I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests')
AND clients.cusername = interests.cusername
ORDER BY CCity, CLastName";
}
else
{
//Use this query when city IS specified
$query = "SELECT CFirstName, CLastName, CCity, CEmail, CID
FROM clients,interests
WHERE (I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests'
AND CCity = '$CCity')
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=\"memberdetails.php?CUserName=$row->CUserName\">$row->CFirstName $row->CLastName</a></td>
############################################################################

		<TD><a href=\"mailto:$row->CEmail\">$row->CEmail</a></td>
		<TD>
		<font size=-1>
			#################################################################################
			<B><a href=\"buddyadded.php?CUserName=$row->CUserName\">Add $row->CUserName to my buddy list</a></b>
			#################################################################################
		</font>
		</td>";
print "</tr>";
}

print "</table>";
print " ";
?>
</td>
</tr>
</table>
 
<a href="searchbyactivity.php">Search again</a>
 
<a href="memberprofile.php?<?=$PHPSESSID; ?>">Back to home</a> 
 
* LDSAlberta.com does its best to regularly screen profiles and ensure they are up to church standards and appropriate in the spirit of the site. If you find any inappropriate profiles or offensive material. 
Please <a href="badprofile.php" target="new_window">click here</a> to report them and we will follow-up on this matter shortly. 
</body>

chongallen

I think you might have to "urlencode" the variable values before passing it?...Don't quote me on it...I might be wrong...but if I'm right could you please tell me. Thanks.
You will have to decode it after it is passed to the script in order for the script to use the variable values...or so I've been told.

Function: urlencode() and urldecode()

Allen.