<?php

if(isset($_POST['submit'])){

$problem = FALSE;

if(empty($_POST['search'])){

$problem = TRUE;

echo "<p style=\"color:#FF0000;\">paieskos zodis</p>";

}

if(!$problem){

$text = $_POST['search'];

$query = "SELECT * from LENTELE WHERE kasnors LIKE '%$text%' OR kaskita LIKE '%$text%' OR darkas LIKE '%$text%'";

$result = @mysql_query($query);

if($result){

echo "<h1>Rezultatai:" . mysql_num_rows($result) . "</h1><br />";

echo "<ul>";

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){

$view = '?puslapiaiikurnukreipi=4&' . $row['id'];

echo '<li><a href="' . $view . '">' . $row['title'] . '</a> - ' . $row['author'] . '</li>';

}

echo "</ul><br />

";

}else{echo"Nieko nerasta";}

}

}

else

{

?>

<form id="search" action="" method="post">

Ieskomas zodis: <input type="text" name="search" size="30" class="text" /><br />

<input type="submit" name="submit" class=button value="Ieskoti" />

</form>

<?php

}

?>

</body>

</html>