<?

include("config.inc.php");

$type = $_POST['search'];
$term = $_POST['searchterm'];

if (!empty($type) && !empty($term))
{
$query = "SELECT * FROM land_test WHERE $type = '$term' ";
}

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM vand_chatlog";
$result=mysql_query($query);

?> 

<?
$i=0;
while ($i < $num) {
$keywods=mysql_result($result,$i,"keywods");
$text=mysql_result($result,$i,"text");
$catagory=mysql_result($result,$i,"catagory");

?>

<?echo "$keywords"; ?>