hey, Im having 2 very strange problems. This is a long block of code but it shows virtually the exact same if statements, and the 3rd one is getting the error when there are virtually identical.

if($uh=="houses")
{
echo"hey";
if($house=="g")
{
$v="g";
$result=mysql_query("select from members where username='".$u_name."' and house=$v");
$result1=mysql_query("select
from members where username='".$u_name."'");
$g="Gryffindor";
$h="Hufflepuff";
$r="Ravenclaw";
$s="Slytherin";
if(mysql_num_rows($result)==0)
{
$row=mysql_fetch_array($result1);
require(leftin);
echo "You don't belong in this house! <b>3 points from ";
if($row["house"]="g")
{
echo "Gryffindor!</b>";
exit;
}
elseif($row["house"]="h")
{
echo "Hufflepuff!";
exit;
}
elseif($row["house"]="r")
{
echo "Ravenclaw!";
exit;
}
elseif($row["house"]="s")
{
echo "Slytherin!";
exit;
}
require(right);
exit;
}
$result=mysql_query("update members where uname='".$u_name."' set points=3");
}
$image="<center><img src='gryheader.jpg'></center>";
$color="#ff0000";
require(leftin);
echo "<br>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>|
<a href='uh.php?uh=class&class=dada'>Defense Against the Dark Arts</a> | <a href='uh.php?uh=class&class=care'>Care
of Magical Creatures</a> | <a href='uh.php?uh=class&class=charms'>Charms</a>
| <a href='uh.php?uh=class&class=trans'>Tranfisguration</a> | <a href='uh.php?uh=class&class=potions'>Potions</a>
| <br>
<a href='uh.php?uh=page'>Get Wizard Money</a> | <a href='uh.php?uh=greathall'>Great
Hall</a></font></div>
<br><br> <div align='center'>
<p>$image</p>
<center><table width='80%' border='0' cellspacing='0' cellpadding='0'>";
$result=mysql_query("select * from hboards where id=$v order by id1 desc limit 0,49");
for($i=0; $i<mysql_num_rows($result); $i++)
{
$row=mysql_fetch_array($result);
echo "<tr>
<td width='25%'>
<div align='left'><font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'><a href='uh.php?uh=bio&name=".$row["username"]."'>".$row["username"]."
<b>|</b> </div>

<td width='75%'>
 <font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'> ".$row["message"]."</font></td>

</tr>";
}
echo "</table></center>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FFFFFF'>Converse
with other Students</font></p>
<form name='form1' method='post' action='uh.php?uh=post'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='000000'>
<input type='hidden' value=$v name='location'>
<input name='message' maxlength='30' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FACE: Verdana, Arial, Helvetica, sans-serif'FONT-SIZE: 8pt' size='25'>
</font>
<input name='Proceed2' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FAMILY: arial; FONT-SIZE: 8pt' type='submit' value='Converse'>
</div>
</form>
<p>&nbsp;</p>
</td>
<td>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&n";bsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
";
require(right);
}
elseif($house=="h")
{
$v="h";
$result=mysql_query("select from members where username='".$u_name."' and house=$v");
$result1=mysql_query("select
from members where username='".$u_name."'");
$g="Gryffindor";
$h="Hufflepuff";
$r="Ravenclaw";
$s="Slytherin";
if(mysql_num_rows($result)==0)
{
$row=mysql_fetch_array($result1);
require(leftin);
echo "You don't belong in this house! <b>3 points from ";
if($row["house"]="g")
{
echo "Gryffindor!</b>";
exit;
}
elseif($row["house"]="h")
{
echo "Hufflepuff!";
exit;
}
elseif($row["house"]="r")
{
echo "Ravenclaw!";
exit;
}
elseif($row["house"]="s")
{
echo "Slytherin!";
exit;
}
require(right);
exit;
}
$result=mysql_query("update members where uname='".$u_name."' set points=3");
}
$image="<center><img src='gryheader.jpg'></center>";
$color="#ff0000";
require(leftin);
echo "<br>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>|
<a href='uh.php?uh=class&class=dada'>Defense Against the Dark Arts</a> | <a href='uh.php?uh=class&class=care'>Care
of Magical Creatures</a> | <a href='uh.php?uh=class&class=charms'>Charms</a>
| <a href='uh.php?uh=class&class=trans'>Tranfisguration</a> | <a href='uh.php?uh=class&class=potions'>Potions</a>
| <br>
<a href='uh.php?uh=page'>Get Wizard Money</a> | <a href='uh.php?uh=greathall'>Great
Hall</a></font></div>
<br><br> <div align='center'>
<p>$image</p>
<center><table width='80%' border='0' cellspacing='0' cellpadding='0'>";
$result=mysql_query("select * from hboards where id=$v order by id1 desc limit 0,49");
for($i=0; $i<mysql_num_rows($result); $i++)
{
$row=mysql_fetch_array($result);
echo "<tr>
<td width='25%'>
<div align='left'><font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'><a href='uh.php?uh=bio&name=".$row["username"]."'>".$row["username"]."
<b>|</b> </div>

<td width='75%'>
 <font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'> ".$row["message"]."</font></td>

</tr>";
}
echo "</table></center>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FFFFFF'>Converse
with other Students</font></p>
<form name='form1' method='post' action='uh.php?uh=post'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='000000'>
<input type='hidden' value=$v name='location'>
<input name='message' maxlength='30' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FACE: Verdana, Arial, Helvetica, sans-serif'FONT-SIZE: 8pt' size='25'>
</font>
<input name='Proceed2' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FAMILY: arial; FONT-SIZE: 8pt' type='submit' value='Converse'>
</div>
</form>
<p>&nbsp;</p>
</td>
<td>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
";
require(right);
}
if($house=="r")
{
$v="r";
$result=mysql_query("select from members where username='".$u_name."' and house=$v");
$result1=mysql_query("select
from members where username='".$u_name."'");
$g="Gryffindor";
$h="Hufflepuff";
$r="Ravenclaw";
$s="Slytherin";
if(mysql_num_rows($result)==0)
{
$row=mysql_fetch_array($result1);
require(leftin);
echo "You don't belong in this house! <b>3 points from ";
if($row["house"]="g")
{
echo "Gryffindor!</b>";
exit;
}
elseif($row["house"]="h")
{
echo "Hufflepuff!";
exit;
}
elseif($row["house"]="r")
{
echo "Ravenclaw!";
exit;
}
elseif($row["house"]="s")
{
echo "Slytherin!";
exit;
}
require(right);
exit;
}
$result=mysql_query("update members where uname='".$u_name."' set points=3");
}
$image="<center><img src='gryheader.jpg'></center>";
$color="#ff0000";
require(leftin);
echo "<br>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>|
<a href='uh.php?uh=class&class=dada'>Defense Against the Dark Arts</a> | <a href='uh.php?uh=class&class=care'>Care
of Magical Creatures</a> | <a href='uh.php?uh=class&class=charms'>Charms</a>
| <a href='uh.php?uh=class&class=trans'>Tranfisguration</a> | <a href='uh.php?uh=class&class=potions'>Potions</a>
| <br>
<a href='uh.php?uh=page'>Get Wizard Money</a> | <a href='uh.php?uh=greathall'>Great
Hall</a></font></div>
<br><br> <div align='center'>
<p>$image</p>
<center><table width='80%' border='0' cellspacing='0' cellpadding='0'>";
$result=mysql_query("select * from hboards where id=$v order by id1 desc limit 0,49");
for($i=0; $i<mysql_num_rows($result); $i++)
{
$row=mysql_fetch_array($result);
echo "<tr>
<td width='25%'>
<div align='left'><font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'><a href='uh.php?uh=bio&name=".$row["username"]."'>".$row["username"]."
<b>|</b> </div>

<td width='75%'>
 <font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'> ".$row["message"]."</font></td>

</tr>";
}
echo "</table></center>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FFFFFF'>Converse
with other Students</font></p>
<form name='form1' method='post' action='uh.php?uh=post'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='000000'>
<input type='hidden' value=$v name='location'>
<input name='message' maxlength='30' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FACE: Verdana, Arial, Helvetica, sans-serif'FONT-SIZE: 8pt' size='25'>
</font>
<input name='Proceed2' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FAMILY: arial; FONT-SIZE: 8pt' type='submit' value='Converse'>
</div>
</form>
<p>&nbsp;</p>
</td>
<td>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
";
require(right);
}
if($house=="s")
{
$v="s";
$result=mysql_query("select from members where username='".$u_name."' and house=$v");
$result1=mysql_query("select
from members where username='".$u_name."'");
$g="Gryffindor";
$h="Hufflepuff";
$r="Ravenclaw";
$s="Slytherin";
if(mysql_num_rows($result)==0)
{
$row=mysql_fetch_array($result1);
require(leftin);
echo "You don't belong in this house! <b>3 points from ";
if($row["house"]="g")
{
echo "Gryffindor!</b>";
exit;
}
elseif($row["house"]="h")
{
echo "Hufflepuff!";
exit;
}
elseif($row["house"]="r")
{
echo "Ravenclaw!";
exit;
}
elseif($row["house"]="s")
{
echo "Slytherin!";
exit;
}
require(right);
exit;
}
$result=mysql_query("update members where uname='".$u_name."' set points=3");
}
$image="<center><img src='gryheader.jpg'></center>";
$color="#ff0000";
require(leftin);
echo "<br>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>|
<a href='uh.php?uh=class&class=dada'>Defense Against the Dark Arts</a> | <a href='uh.php?uh=class&class=care'>Care
of Magical Creatures</a> | <a href='uh.php?uh=class&class=charms'>Charms</a>
| <a href='uh.php?uh=class&class=trans'>Tranfisguration</a> | <a href='uh.php?uh=class&class=potions'>Potions</a>
| <br>
<a href='uh.php?uh=page'>Get Wizard Money</a> | <a href='uh.php?uh=greathall'>Great
Hall</a></font></div>
<br><br> <div align='center'>
<p>$image</p>
<center><table width='80%' border='0' cellspacing='0' cellpadding='0'>";
$result=mysql_query("select * from hboards where id=$v order by id1 desc limit 0,49");
for($i=0; $i<mysql_num_rows($result); $i++)
{
$row=mysql_fetch_array($result);
echo "<tr>
<td width='25%'>
<div align='left'><font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'><a href='uh.php?uh=bio&name=".$row["username"]."'>".$row["username"]."
<b>|</b> </div>

<td width='75%'>
 <font size='1' face='Verdana, Arial, Helvetica, sans-serif' color='$color'> ".$row["message"]."</font></td>

</tr>";
}
echo "</table></center>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='#FFFFFF'>Converse
with other Students</font></p>
<form name='form1' method='post' action='uh.php?uh=post'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1' color='000000'>
<input type='hidden' value=$v name='location'>
<input name='message' maxlength='30' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FACE: Verdana, Arial, Helvetica, sans-serif'FONT-SIZE: 8pt' size='25'>
</font>
<input name='Proceed2' style='FONT-SIZE: 10px; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #color; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #000000; FONT-FAMILY: arial; FONT-SIZE: 8pt' type='submit' value='Converse'>
</div>
</form>
<p>&nbsp;</p>
</td>
<td>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
";
require(right);
}
}

I connected to the MySQL DB... Im getting the error here:

require(right);
} ------error
if($house=="s")

And Im also getting an error in this script:

if($uh=="bio")
{
require(leftin);
$result=mysql_query("select from members where username='".$name."'");
if(mysql_num_rows($result)>0)
{
$row=mysql_fetch_array($result);
echo "<center><table width='50%' border='0'>
<tr align='left' valign='top'>
<td>
<center><b>".$row["username"]."</b></center><br><br>
Email Address:".$row["email"]."<br>
Name:".$row["fname"]."<br>
Age:".$row["age"]."<br>
Gender:".$row["sex"]."<br>";
if($row["house"]=="g")
{
echo "House:Gryffindor<br>";
exit;
}
elseif($row["house"]=="h")
{
echo "House:Hufflepuff<br>";
exit;
}
elseif($row["house"]=="r")
{
echo "House:Ravenclaw<br>";
exit;
}
elseif($row["house"]=="s")
{
echo "House:Slytherin<br>";
exit;
}
echo "Quote:".$row["quote"]."<br>";
}
else
{
require(leftin);
echo "No user found.";
require(right);
exit;
}
}
elseif($uh=="page")
{
if(!isset($ad))
{
require(leftin);
echo "<div align='center'>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>Earn Wizard Money
by signing-up with the below sponsors</font></p>
<p>&nbsp;</p>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>100 Sickles<br>
<a href='profile.php?uh=page&ad=1&name=$u_name' target='fssdsdf'><img src='http://www.qksrv.net/image-976965-5367478' width='234' height='60' alt='null' border='0'></a></font></p>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>100 Sickles<br>
<a href='profile.php?uh=page&ad=2&name=$u_name' target='sdfdsdsd'><img src='http://www.qksrv.net/image-976965-1194341' width='88' height='31' alt='Click to get a free mouse pad with free shipping!' border='0'></a>
</font></p>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>100 Sickles<br>
<a href='profile.php?uh=page&ad=3&name=$u_name' target='sfdsdsdsd'><img src='http://www.qksrv.net/image-976965-3998646' width='234' height='60' alt='null' border='0'></a>
</font></p>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>100 Sickles<br>
<a href='profile.php?uh=page&ad=4&name=$u_name' target='dsfdssd'><img src='http://www.qksrv.net/image-976965-1179711' width='234' height='60' alt='null' border='0'></a>
</font></p>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>0 Sickles, Signing
up with this sponsor would be greatly appreciated</font></p>
<p> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>
<!-- Begin Focalex Signup Form Copyright 1999-2002 Focalex Inc. DO NOT MODIFY. -->
<script language='Javascript' src='http://www.focalex.com/code/embedded_form.mpl?type=js&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id='></script>
<noscript><br>
<iframe src='http://www.focalex.com/code/embedded_form.mpl?type=iframe&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id=' frameborder='0' border='0' framspacing='0' marginheight='0' marginiwdth='0' scrolling='no' vspace='0' hspace='0' width='595' height='195'>
</iframe></noscript></font></p>
<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><noscript><iframe src='http://www.focalex.com/code/embedded_form.mpl?type=iframe&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id=' frameborder='0' border='0' framspacing='0' marginheight='0' marginiwdth='0' scrolling='no' vspace='0' hspace='0' width='595' height='195'>
</iframe></noscript><noscript><iframe src='http://www.focalex.com/code/embedded_form.mpl?type=iframe&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id=' frameborder='0' border='0' framspacing='0' marginheight='0' marginiwdth='0' scrolling='no' vspace='0' hspace='0' width='595' height='195'>
</iframe></noscript></font><font size='1'><noscript><iframe src='http://www.focalex.com/code/embedded_form.mpl?type=iframe&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id=' frameborder='0' border='0' framspacing='0' marginheight='0' marginiwdth='0' scrolling='no' vspace='0' hspace='0' width='595' height='195'>
</iframe></noscript></font><noscript><iframe src='http://www.focalex.com/code/embedded_form.mpl?type=iframe&lname=general&cols=4&banner=&outerBgColor=%23ccff66&innerBgColor=%23ffffff&fontColor=%23000000&aid=245985&gatherer_id=' frameborder='0' border='0' framspacing='0' marginheight='0' marginiwdth='0' scrolling='no' vspace='0' hspace='0' width='595' height='195'>
<table cellspacing='0' cellpadding='3' border='0' bgcolor='#ccff66'>
<form target='top' method='POST' action='http://www.focalex.com/subscriber/subscribe.mpl' onsubmit='return ( (this.email.value.indexOf('@')>0 && this.email.value.indexOf('.')>0) ? alert('Congratulations, you are being subscribed! Check your email to reply to our welcome email!') : (alert('Please enter a valid email address.') || false) )'>
<font face='Verdana, Arial, Helvetica, sans-serif' size='1'>
<input type='hidden' name='affiliate_id' value='245985'>
<input type='hidden' name='form_type' value='embedded'>
<input type='hidden' name='form_version' value='general_2.0'>
</font>
<tr>
<td align='center'>
<table cellpadding='1' cellspacing='1' border='0'>
<tr>
<td align='center'><font size='1' color='#000000' face='Verdana, Arial, Helvetica, sans-serif' style='font-size:14pt'>
<strong>Pick your topics, and we'll send you great deals, free
<br>
information, and special offers by email from Focalex.</strong>
</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align='center'>
<table border='0' cellspacing='0' cellpadding='0' bgcolor='#ffffff'>
<tr>
<td align='center'>
<table border='0' cellspacing='0' cellpadding='0' bgcolor='#ffffff'>
<tr>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='254' checked>
Free/Special Offers</font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='273'>
Small Business </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='161'>
Books </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='257'>
Home Based Office </font></td>
</tr>
<tr>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='172'>
Music </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='1203'>
IT Professional </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='213'>
Personal Finance </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='174'>
Sports </font></td>
</tr>
<tr>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='179'>
Travel </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='341'>
Credit Cards </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='76'>
Health </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='1501'>
Business Travel </font></td>
</tr>
<tr>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='212'>
Online Financial </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='406'>
Computer Hardware </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='130'>
Cooking </font></td>
<td nowrap><font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:8pt;'>
<input type='checkbox' name='list_id' value='300'>
Consumer Electronics </font></td>
</tr>
</table>
</td>
</tr>
</table>
<table border='0' cellpadding='0' cellspacing='0' width='95%'>
<tr>
<td align='center' nowrap> <font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:10pt'>
E-mail:
<input type='text' name='email' maxlength='50' size='15'>
</font></td>
<td align='center' nowrap> <font color='#000000' face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:10pt'>
Zip Code:
<input type='text' name='zip' size='5' maxlength='25'>
</font></td>
<td align='center' nowrap> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>
<input type='submit' name='x' value='Sign Up!'>
</font></td>
</tr>
<tr>
<td colspan='3' align='center'> <font face='Verdana, Arial, Helvetica, sans-serif' size='1' style='font-size:10pt'> <b>
<A href='http://www.focalex.com/subs.emp?aid=245985' target='
blank'><font color='#000000'>Other
Great Lists</font></a>&nbsp; &nbsp;<a href='http://www.focalex.com/affiliates/?pc=245985&ban=esf'><font color='#000000'>Webmasters
make money.</font></a></b></font><b> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'></font></b></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</iframe> </noscript> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>
<!-- End Focalex Signup Form Copyright 1999-2002 Focalex Inc. DO NOT MODIFY. -->
</font></div>";
require(right);
}
elseif(isset($ad))
{
$result=mysql_query("select
from sponsors where username='".$u_name."' and id='".$ad."'");
if(mysql_num_rows($result)>0)
{
echo "You have already registered with this sponsor.";
exit;
}
$result=mysql_query("insert into sponsors values
('".$u_name."','".$ad."');
if($ad==1)
{
echo "Redirect";
}
elseif($ad==2)
{
echo "<head><meta http-equiv='Refresh' content='0; URL=http://www.qksrv.net/click-976965-1194341'></head></table></center>";
}
elseif($ad==3)
{
echo "<head><meta http-equiv='Refresh' content='0; URL=http://www.qksrv.net/click-976965-3998646'></head>";
}
elseif($ad==4)
{
echo "<head><meta http-equiv='Refresh' content='0; URL=http://www.qksrv.net/click-976965-1179711'></head>";
}
}
}

I get the error on each of the echo statements shown in the if($ad==#) statements, the echo "redirect" statements.

Thanks for any help you might have...

    "The writers may write, and the users may use, but the fixers must fix... with minimal clues." That's my favorite saying, having worked in Internet Tech Support for over 2 years now. And I'm going to ask you the same thing I ask every grandma over 85 that calls me day in and day out: "What is the exact error message?" Which I'm sure you'll understand will help optically parsing through hundreds of lines of code because it provides a focus.

      Normally I wouldn't go near that post with womeone else's 10 foot pole, but the answer seems to be right at the end...

      $result=mysql_query("insert into sponsors values ('$u_name', '$ad')");

      Is how that should look.

        Parse error: parse error in /home/sites/site43/web/uh/uh.php

          I agree... going through an entire site's code is not something helpful types are willing to do often... mostly because that's part of the reason people have jobs for that. The kind where they are paid money. But good work on tracking that one down, after he posted the error from my earlier comment it seems to match up with the bug you found.

          Majik Sheff wrote:

          Normally I wouldn't go near that post with womeone else's 10 foot pole, but the answer seems to be right at the end...

          $result=mysql_query("insert into sponsors values ('$u_name', '$ad')");

          Is how that should look.

            Thanks, nice to have someone not shooting me down. AHEM VINCENT G

              Write a Reply...