PHP: Vyhledávání

|-------------------------------|
| word        | description  |
|-------------------------------|
|ctf             | gametype    |
|-------------------------------|
|instagib    | server mod  |
|-------------------------------|

$query = mysql_query("SELECT * FROM dictionary_words WHERE word LIKE '".$what."'");

<?php
include "functions.php";
if ($_POST["status"] == "2") {
//Find in MySQL proccess
$link = mysql_connect("localhost", "twd", "password") or exit("Unable to connect to database. Please contact webmaster");
$dbselect = mysql_select_db("teeworlds_dictionary") or exit("Unable to select database. Please contact webmaster");
$what = StringInput($_POST["sts"]);
$query = mysql_query("SELECT * FROM dictionary_words WHERE word='".$what."'");
$radku=mysql_num_rows($query);
if ($radku==0) echo "We are sorry, but the word \"".$what."\" are not in TeeWorlds dictionary :-(";
else
 {
 echo "Search results:<BR>";
 while ($zaznam = MySQL_Fetch_Array($query)):
 echo "<br><b>Word:</b> ";
 echo $zaznam["word"];
 echo "<br><b>Description:</b><br>";
 echo $zaznam["description"]."<BR><HR><BR>\n";
 endwhile;
}
}
else {
//View form
generateHeader();
echo '
<fieldset>
<form action="find.php" method="post">
String to search:<br>
<input type="text" name="sts" size="30"><br>
<input type="hidden" name="status" value="2">
<input type="submit" value="Send">
</form>
</fieldset>
';
generateFooter();
}
?>

Resource id #4