Can't figure out why I get this error!

cybersounds

For some reason I get this error that says

"Parse error: parse error, unexpected $ in /home/jabcpa/public_html/allclients.php on line 600."

I believe this is caused in a filter section of my page where the user can filter the records by field and search term. Here's the code:

<fieldset><legend align="center"><b>Filter Your Query</b></legend>
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php

@ $db = mysql_pconnect('host', 'username', 'pw');
mysql_select_db('dbname');

if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}

if(!$FilterSubmit)
{
?>
Query Type:
<select name="searchtype">
<option value="fullname">Name</option>
<option value="city">City</option>
<option value="state">State</option>
<option value="service">Service</option>
<option value="review">Review Type</option>
<option value="reviewyear">Review Year</option>
</select>
<br />
Query Term:
<input name="searchterm" type="text">
<br />
<input type="submit" name="FilterSubmit" value="Filter">

<?php
}
if($FilterSubmit == 'Filter')
{
if (!$Submit)
{
//create short variable names
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm= trim($searchterm);

if (!$searchtype || !$searchterm)
{
echo 'You have not entered search details. Please go back and try again.';
exit;
}

$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);

$query = "select * from webform where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

echo '<p>Number of clients found: '.$num_results.'</p>';

while($r = mysql_fetch_array($result))
{

$id=$r["id"];
$fullname=$r["fullname"];
$address=$r["address"];
$city=$r["city"];
$state=$r["state"];
$zip=$r["zip"];
$phone=$r["phone"];
$extension=$r["extension"];
$fax=$r["fax"];
$email=$r["email"];
$service=$r["service"];
$review=$r["review"];
$reviewduemonth=$r["reviewduemonth"];
$reviewdueday=$r["reviewdueday"];
$reviewdueyear=$r["reviewdueyear"];
?>
<input type="radio" name="id" value="<?php echo $id;?>">
<?php echo $fullname; ?><br />
<?php echo $address; ?><br />
<?php echo $city; ?>, <?php echo $state; ?> <?php echo $zip; ?><br />
Tel: <?php echo $phone; ?> Ext: <?php echo $extension; ?><br />
Fax: <?php echo $fax; ?><br />
Email: <?php echo $email; ?><br />
Service: <?php echo $service; ?><br />
Peer Review: <?php echo $review; ?><br />
Peer Review Date: <?php echo $reviewduemonth; ?> <?php echo $reviewdueday; ?>,
<?php echo $reviewdueyear; ?>
<br /><br />
<a href="viewdatabase.php">Unfilter database</a>
<?php
}
?>

<?php
}
?>

<?php
if($Submit == 'Edit')
{
if (!$EditClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>
<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:<input type="text name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,

State:<select name="state">
<option>AL<option>AK<option>AZ<option>AR<option>CA<option>CO<option>CT<option>DE<option>DC<option>FL<option>GA<option>HI<option>ID<option>IL<option>IN<option>IA<option>KS<option>KY<option>LA<option>ME<option>MD<option>MA<option>MI<option>MN<option>MS<option>MO<option>MT<option>NE<option>NV<option>NH<option>NJ<option>NM<option>NY<option>NC<option>ND<option>OH<option>OK<option>OR
<option>PA<option>RI<option>SC<option>SD<option>TN<option>TX<option>UT
<option>VT<option>VA<option>WA<option>WV<option>WI<option>WY
</select>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />

Service:
<input type="radio" name="service" value="Accounting/Auditing" />
Accounting/Auditing<br />
<input type="radio" name="service" value="Tax Services" />
Tax Services<br />
<input type="radio" name="service" value="Management Advisory" />
Management Advisory<br />
<input type="radio" name="service" value="Investment Planning" />
Investment Planning<br />
<input type="radio" name="service" value="Peer Review" />Peer Review

Peer Review type if applicable:<br />
<input type="radio" name="review" value="System Review" />
System Review<br />
<input type="radio" name="review" value="Engagement Review" />
Engagement Review<br />
<input type="radio" name="review" value="Report Review" />
Report Review<br />

Peer Review Due Date if applicable:<br />

<select name="reviewduemonth">
<option selected>
<option>January<option>February<option>March<option>April<option>May<option>June<option>July<option>August<option>September<option>October<option>November
<option>December
</select>

<br />

<input type="hidden" name="Submit" value="Edit">
<input type="submit" name="EditClient" value="Edit client">
<input type="submit" name="Cancel" value="Cancel">
</form>
<?php
}

if($EditClient)
{
$sql = "UPDATE webform SET fullname=$fullname, address=$address, city=$city, state=$state, zip=$zip, phone=$phone, extension=$extension, fax=$fax, email=$email, service=$service, review=$review, reviewduemonth=$reviewduemonth, reviewdueday=$reviewdueday, reviewdueyear=$reviewdueyear WHERE id=$id";
$result = mysql_query($sql);
echo "Client Updated<br /><br /><a href='allclients.php'>Back to client results</a>";
}
if($Cancel)
{
echo "Update canceled<br /><br /><a href='allclients.php'>Back to client results</a>";
}
}
?>

<?php
if($Submit == 'Delete')
{
if (!$DeleteClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>

<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:<input type="text name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,

State:<input type="text" name="state" value="<?php echo $myrow["state"]; ?>" size=2>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />

Service:
<input type="text" name="service" value="<?php echo $myrow["service"]; ?>" size=17>

Peer Review type if applicable:
<input type="text" name="review" value="<?php echo $myrow["review"]; ?>" size=17><br />

Peer Review Due Date if applicable:
<input type="text" name="reviewduemonth" value="<?php echo $myrow["reviewduemonth"]; ?>" size=9>
<input type="text" name="reviewdueday" value="<?php echo $myrow["reviewdueday"]; ?>" size=2>
<input type="text" name="reviewdueyear" value="<?php echo $myrow["reviewdueyear"]; ?>" size=4>

<br />

<?php
}

if($DeleteClient)
{
$sql = "DELETE FROM webform WHERE id=$id";
$result = mysql_query($sql);
echo "Client Deleted<br /><br /><a href='allclients.php'>Back to client results</a>";
}
if($Cancel)
{
echo "Delete canceled<br /><br /><a href='allclients.php'>Back to client results</a>";
}
}
?>
</form>
</fieldset>

laserlight

Offhand I'd say indent your code, check that your code blocks are correct (i.e. for every "{" there should be a "}")

cybersounds

OK, I did that, and then I even reshuffled the code around a little like so and now I get theses errors:

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jabcpa/public_html/searchclients.php on line 117"

and also

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jabcpa/public_html/searchclients.php on line 127"

Here is my code:

<fieldset><legend align="center"><b>Filter Your Query</b></legend>
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php

@ $db = mysql_pconnect('host', 'username', 'ps');
mysql_select_db('dbname');

if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}

<?php
}
if($FilterSubmit == 'Filter')
{
if (!$Submit)
{

   $query = "select * from webform where ".$searchtype."like '%".$searchterm."%'";
   $result = mysql_query($query);
   $num_results = mysql_num_rows($result);

   echo '<p>Number of clients found: '.$num_results.'</p>';

   if (!$searchtype || !$searchterm)
     {
   	  echo 'You have not entered search details. Please go back and try again.';
   	  exit;
 }

   while($r = mysql_fetch_array($result)) 
     {     
      $id=$r["id"]; 
      $fullname=$r["fullname"]; 
      $address=$r["address"]; 
      $city=$r["city"]; 
      $state=$r["state"]; 
      $zip=$r["zip"];
      $phone=$r["phone"];
      $extension=$r["extension"];
      $fax=$r["fax"];
      $email=$r["email"]; 
      $service=$r["service"]; 
      $review=$r["review"]; 
      $reviewduemonth=$r["reviewduemonth"];
      $reviewdueday=$r["reviewdueday"];
      $reviewdueyear=$r["reviewdueyear"]; 

      $searchtype=$HTTP_POST_VARS['searchtype'];
  $searchterm=$HTTP_POST_VARS['searchterm'];
  $searchterm= trim($searchterm);
  $searchtype = addslashes($searchtype);
      $searchterm = addslashes($searchterm);

?>
<input type="radio" name="id" value="<?php echo $id;?>">
<?php echo $fullname; ?><br />
<?php echo $address; ?><br />
<?php echo $city; ?>, <?php echo $state; ?> <?php echo $zip; ?><br />
Tel: <?php echo $phone; ?> Ext: <?php echo $extension; ?><br />
Fax: <?php echo $fax; ?><br />
Email: <?php echo $email; ?><br />
Service: <?php echo $service; ?><br />
Peer Review: <?php echo $review; ?><br />
Peer Review Date: <?php echo $reviewduemonth; ?> <?php echo $reviewdueday; ?>,
<?php echo $reviewdueyear; ?>
<br /><br />
<a href="viewdatabase.php">Unfilter database</a>
<?php
}
?>

<?php
}
?>

Peer Review Due Date if applicable:<br />

<br />

<?php
if($Submit == 'Delete')
{
if (!$DeleteClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>

Service:
<input type="text" name="service" value="<?php echo $myrow["service"]; ?>" size=17>

Peer Review type if applicable:
<input type="text" name="review" value="<?php echo $myrow["review"]; ?>" size=17><br />

<br />

cahva

There should be space before LIKE:

$query = "select * from webform where ".$searchtype." like '%".$searchterm."%'";

cybersounds

Always have to be those stupid syntax errors!!! Thanks so much.

cybersounds

Now the search filter works fine with no errors, but once I've selected a record and either click delete or edit, I'm returned to the search option where I should be sent to the edit or delete option. Here's the code:

<fieldset><legend align="center"><b>Filter Your Query</b></legend>
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php

@ $db = mysql_pconnect('host', 'username', 'pw');
mysql_select_db('dbname');

if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}

<?php
}
if($FilterSubmit == 'Filter')
{
if (!$Submit)
{

$query = "select * from webform where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

   echo '<p>Number of clients found: '.$num_results.'</p>';

   if (!$searchtype || !$searchterm)
     {
   	  echo 'You have not entered search details. Please go back and try again.';
   	  exit;
 }

   while($r = mysql_fetch_array($result)) 
     {     
      $id=$r["id"]; 
      $fullname=$r["fullname"]; 
      $address=$r["address"]; 
      $city=$r["city"]; 
      $state=$r["state"]; 
      $zip=$r["zip"];
      $phone=$r["phone"];
      $extension=$r["extension"];
      $fax=$r["fax"];
      $email=$r["email"]; 
      $service=$r["service"]; 
      $review=$r["review"]; 
      $reviewduemonth=$r["reviewduemonth"];
      $reviewdueday=$r["reviewdueday"];
      $reviewdueyear=$r["reviewdueyear"]; 

      $searchtype=$HTTP_POST_VARS['searchtype'];
  $searchterm=$HTTP_POST_VARS['searchterm'];
  $searchterm= trim($searchterm);
  $searchtype = addslashes($searchtype);
      $searchterm = addslashes($searchterm);

<?php
}
?>

<?php
if($Submit == 'Edit')
{
if (!$EditClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>
<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:
<input type="text" name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,

State:<select name="state">
<option>AL<option>AK<option>AZ<option>AR<option>CA<option>CO<option>CT<option>DE<option>DC<option>FL<option>GA<option>HI<option>ID<option>IL<option>IN<option>IA<option>KS<option>KY<option>LA<option>ME<option>MD<option>MA<option>MI<option>MN<option>MS<option>MO<option>MT<option>NE<option>NV<option>NH<option>NJ<option>NM<option>NY<option>NC<option>ND<option>OH<option>OK<option>OR
<option>PA<option>RI<option>SC<option>SD<option>TN<option>TX<option>UT
<option>VT<option>VA<option>WA<option>WV<option>WI<option>WY
</select>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />

Peer Review Due Date if applicable:<br />

<br />

<input type="hidden" name="Submit" value="Edit">
<input type="submit" name="EditClient" value="Edit client">
<input type="submit" name="Cancel" value="Cancel">
</form>
<?php
}

if($EditClient)
{
$sql = "UPDATE webform SET fullname='$fullname', address='$address', city='$city', state='$state', zip='$zip', phone='$phone', extension='$extension', fax='$fax', email='$email', service='$service', review='$review', reviewduemonth='$reviewduemonth', reviewdueday='$reviewdueday', reviewdueyear='$reviewdueyear' WHERE id='$id'";
$result = mysql_query($sql);
echo "Client Updated<br /><br /><a href='accessdatabase.php'>Back to main menu</a>";
}
if($Cancel)
{
echo "Update canceled<br /><br /><a href='accessdatabase.php'>Back to main menu</a>";
}
}
?>

<?php
if($Submit == 'Delete')
{
if (!$DeleteClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>

<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:
<input type="text" name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,

State:<input type="text" name="state" value="<?php echo $myrow["state"]; ?>" size=2>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />

Service:
<input type="text" name="service" value="<?php echo $myrow["service"]; ?>" size=17>

Peer Review type if applicable:
<input type="text" name="review" value="<?php echo $myrow["review"]; ?>" size=17><br />

<br />

<?php
}

if($DeleteClient)
{
$sql = "DELETE FROM webform WHERE id=$id";
$result = mysql_query($sql);
echo "Client Deleted<br /><br /><a href='accessdatabase.php'>Back to main menu</a>";
}
if($Cancel)
{
echo "Delete canceled<br /><br /><a href='accessdatabase.php'>Back to main menu</a>";
}
}
}
?>
</form>
</fieldset>