Dynamic Query Parse Error

[weazy]

Hello,
I am working on a query that pulls search terms out of a form, but am getting a parse error. I am hoping one of the PHP gurus on this board can give me a tip.

The parse error indicates its the line with the first "if" statement.

thanks in advance.

<?

if ($HTTP_POST_VARS["Field"]$Count>0)
{

$strSQL="";
for ($intCount=1; $intCount<=$HTTP_POST_VARS["Field"].$Count; $intCount=$intCount+1)
{

$strSQL=$strSQL.$HTTP_POST_VARS["Field"]($intCount).", ";

}

$strSQL=substr($strSQL,0,strlen($strSQL)-2);
$strSQL="SELECT ".$strSQL." FROM canada WHERE ";
$parameterStr="";

if ($HTTP_POST_VARS["region"]!="")
{

$parameterStr="Region = '".$HTTP_POST_VARS["region"]."'";

}

if ($HTTP_POST_VARS["type"]!="")
{

if ($parameterStr=="")
{

  $parameterStr="Type ".$HTTP_POST_VARS["type"]."";
}
  else
{
  $parameterStr=$parameterStr." AND Type ".$HTTP_POST_VARS["type"]."";
} 

}

if ($HTTP_POST_VARS["name"]!="")
{

if ($parameterStr=="")
{

  $parameterStr="Name LIKE '%".$HTTP_POST_VARS["name"]."%'";
}
  else
{
  $parameterStr=$parameterStr." AND Name LIKE '%".$HTTP_POST_VARS["name"]."%'";
} 

}

if ($HTTP_POST_VARS["contact"]!="")
{

if ($parameterStr=="")
{

  $parameterStr="Contact LIKE '%".$HTTP_POST_VARS["contact"]."%'";
}
  else
{
  $parameterStr=$parameterStr." AND Contact LIKE '%".$HTTP_POST_VARS["contact"]."%'";
} 

}

if ($HTTP_POST_VARS["email"]!="")
{

if ($parameterStr=="")
{

  $parameterStr="Email LIKE '%".$HTTP_POST_VARS["email"]."%'";
}
  else
{
  $parameterStr=$parameterStr." AND Email LIKE '%".$HTTP_POST_VARS["email"]."%'";
} 

}

if ($HTTP_POST_VARS["status"]!="")
{

if ($parameterStr=="")
{

  $parameterStr="Status = '".$HTTP_POST_VARS["status"]."'";
}
  else
{
  $parameterStr=$parameterStr." AND Status = '".$HTTP_POST_VARS["status"]."'";
} 

}

$strSQL=$strSQL.$parameterStr;

}

print "<BR><BR>";
?>

[laserlight]

$HTTP_POST_VARS["Field"]$Count

what is that expression?
That's the one giving the parse error

[weazy]

well the idea is that i want the user to select what info they get back from the search.

say there are 6 fields in the database:

Region
Type
Name
Contact
Email
Status

i want them to be listed on the form with a checkbox, you select the checkbox, when the form searches the database on your entered search criteria (which are the same 6 fields) it displays the attributes you selected.

The effect is that you can search for all records listed in a particular Region, but if you just check Email, then you get everyone's Email address from that region without having to see all the other data.

I know the first few lines are a lame attempt at this :- \

but i am hoping someone can help me.