$z = "Model LIKE '%" . $name .  "%' AND";
$f = "Condition =$coni AND";
$v = "Country =$country AND";
$g = "length BETWEEN $L1 AND $L2";
$s = "AND powerplant='$powerplant'";

		if ($country == "0")
		{$v = "";}

		if ($powerplant == "a")
		{$s = "";}
		
		

	$sql = "select * FROM boats WHERE $z $f $v $g $s LIMIT $startpoint,$perpage;";
	$result =mysql_query($sql);
	

echo "<table width = '60%' border='0' cellspacing = '0' >
<tr>
<th>Model</th>
<th>Length</th>
<th>Engine</th>
<th>Powerplant</th>
<th>Price</th>
<th>Country</th>
<th>Boat ID</th>
<th>CONDITION</th></th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Model'] . "</td>";
  echo "<td>" . $row['length'] . "</td>";
  echo "<td>" . $row['engine'] . "</td>";
  echo "<td>" . $row['powerplant'] . "</td>";
  echo "<td>" . $row['price'] . "</td>";
	
	{$c=$row['Country'];  
	$sql2 = "select * FROM countries WHERE CountryID = $c";
	$result2=mysql_query($sql2);

	while($row2 = mysql_fetch_array($result2)){
	echo "<td>" . $row2['countrylist'] . "</td>";}}
  
  
  
  echo "<td>" . $row['BoatID'] . "</td>";
  echo "<td>" . $row['Condition'] . "</td>";
	
  $joe = $row['BoatID'];
  echo "<td> <form  method='get' action='details.php?go'  id='searchform2'><input type='hidden' name='hideID' value = '$joe'/><input type='submit' name='submit' value='more info'/></form></td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td colspan = '8'> " . '<hr />' . "</td>";
  echo "</tr>";
	
	}
echo "</table>";