elseif Statement

[savagenoob]

Why am I getting an error on this elseif statement? I know its something simple....

 

$agency=$_SESSION['SESS_AGENCY'];
$search=$_POST["keyword"];
$field=$_POST["field"];

if($field == "PolNum"){
     echo  "<table>";
	$query = "SELECT auto.ClientID, home.ClientID, auto.PolNum, home.PolNum FROM auto, home WHERE auto.'$field' OR home.'$field' LIKE '%$search%' AND Agency = '$agency'";
$result = mysql_query($query)or die(mysql_error());
    $numrows = mysql_num_rows($result);
	if($numrows == 0){ echo "No results returned for " . $search; }

while($myrow = mysql_fetch_assoc($result)) {
	$clientid = $myrow['ClientID'];
	$clientdata = mysql_query("SELECT * FROM clients WHERE ID ='$clientid'")or die(mysql_error());
	$client = mysql_fetch_assoc($clientdata);

  echo "<tr><td><a href=\"client.php?ID=$clientid\">" . $client['First_Name'] . " " . $client['Last_Name'] . " " . $myrow['PolNum'] . "</a></td></tr>\""   ;         
        


}
elseif($field == "Last_Name")
{
	?>
        <table>
        <?php
$query = "SELECT * FROM clients WHERE $field LIKE '%$search%' AND Agency = '$agency'";
$result = mysql_query($query)or die(mysql_error());


 while($myrow = mysql_fetch_assoc($result)) 
             {//begin of loop 

echo "<tr><td><a href=\"client.php?ID=\"" . $myrow['ID'] . "\">" . $myrow['First_Name'] . " " . $myrow['Last_Name'] . "</a></td></tr> "; 

}
}
?>

[inversesoft123]

Why are you using "else if" ?

 

<?php
$agency=$_SESSION['SESS_AGENCY'];



$search=$_POST["keyword"];



$field=$_POST["field"];



if($field == "PolNum"){
     echo  "<table>";





$query = "SELECT auto.ClientID, home.ClientID, auto.PolNum, home.PolNum FROM auto, home WHERE auto.'$field' OR home.'$field' LIKE '%$search%' AND Agency = '$agency'";



$result = mysql_query($query)or die(mysql_error());
    $numrows = mysql_num_rows($result);





if($numrows == 0){ echo "No results returned for " . $search; }



while($myrow = mysql_fetch_assoc($result)) {





$clientid = $myrow['ClientID'];





$clientdata = mysql_query("SELECT * FROM clients WHERE ID ='$clientid'")or die(mysql_error());





$client = mysql_fetch_assoc($clientdata);

  echo "<tr><td><a href=\"client.php?ID=$clientid\">" . $client['First_Name'] . " " . $client['Last_Name'] . " " . $myrow['PolNum'] . "</a></td></tr>\""   ;         
        






}


if($field == "Last_Name")



{





?>
        <table>
        <?php



$query = "SELECT * FROM clients WHERE $field LIKE '%$search%' AND Agency = '$agency'";



$result = mysql_query($query)or die(mysql_error());









while($myrow = mysql_fetch_assoc($result)) 
             {//begin of loop 

echo "<tr><td><a href=\"client.php?ID=\"" . $myrow['ID'] . "\">" . $myrow['First_Name'] . " " . $myrow['Last_Name'] . "</a></td></tr> "; 

}



}
}
?>

[phpchamps]

put a } before else if. it should be

 

}elseif($field == "Last_Name"){

[shortysbest]

Shouldn't it be

 

else if

rather than

elseif

[chaiwei]

ya.. phpchamps is correct.

 

you are missing 1 }

 

}elseif($field == "Last_Name"){

[savagenoob]

Thanks guys