[SOLVED] MySQL asearch

[ki]

Okay, well I know the search result I have this code, but nothing comes up when i know there are posts in which it contains, say take a look and tell me whats wrong here.

[code]if(isset($HTTP_POST_VARS['submit'])) {

if(!$_POST['search']) {
header("Location: ?page=forum&sub=search");
die();
}
$searchterm = $_POST['search'];
$query = mysql_query("SELECT * FROM `forum_threads` WHERE `text` LIKE %$searchterm%");
while($search = mysql_fetch_object($query)) {
echo $search->id;
}

} else {

echo "<form method=\"POST\" action=\"?page=forum&sub=search\">";
echo "<input type=\"text\" name=\"search\" id=\"search\">";
echo "<input type=\"submit\" name=\"submit\" id=\"submit\">";
echo "</form>";

}[/code]

[marcus]

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

if(!isset($_POST['search'])) {
header("Location: ?page=forum&sub=search");
die();
}else {
$searchterm = $_POST['search'];
$query = mysql_query("SELECT * FROM `forum_threads` WHERE `text` LIKE %$searchterm%");
while($search = mysql_fetch_object($query)) {
echo $search->id;
}
mysql_free_result($query)
}

} else {

echo "<form method=\"POST\" action=\"?page=forum&sub=search\">";
echo "<input type=\"text\" name=\"search\" id=\"search\">";
echo "<input type=\"submit\" name=\"submit\" id=\"submit\">";
echo "</form>";

}
[/code]

[ki]

thanks for the response but i get this error

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/tragical/public_html/index.php on line 422

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tragical/public_html/index.php on line 425

[corbin]

try
[code]
$query = mysql_query("SELECT * FROM `forum_threads` WHERE `text` LIKE '%{$searchterm}%'");
[/code]

Oh and if you plan to publicly use this, I highly suggest you at the least addslashes() the POST input, if your server doesn't do it automatically.

[ki]

Thanks corbin that worked fine, and addlsashes is auto.

[corbin]

Glad it worked, and was just making sure on the slashes thing :p.