Help with querying in mysql through php

[Kalid]

I have been trying for weeks now to create my own search engine, i am trying search for keywords in mysql through a query in php, the keywords are entered in an input box in html. Does anybody know the code or fancy having a bash at it???

This is what i have so far...

$link = mysql_connect('localhost', '', '');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('webpages');

$var = @$_GET['q'];
$trimmed = trim($var);
?>

<?php
$query .= "SELECT * FROM sites WHERE keyword LIKE '%$trimmed%'";
$result = @($query) or die("Couldn't execute query");
?>

<?php
$numrows=mysql_num_rows($numresults);

while ($row= mysql_fetch_array($result)) {
$title = $row["site"];

$currPage = (($s/$limit) + 1);

echo "<br />";

if ($s>=1) {
$prevs=($s-$limit);
print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
Prev 10</a>&nbsp&nbsp;";
}

if (!$result) {
echo("<p>Error performing query: " . mysql_error() .
"</p>");
exit();

while ( $row = mysql_fetch_array($result) )
echo("<p>" . $row["site"] .
"</p>");
}

This is what my search bar and button entail...

<FORM NAME="FORM" ACTION="search.php" METHOD="get">
<FONT COLOR = "#FFFFFF"><INPUT TYPE="text" INPUT MAXLENGTH ="256" SIZE ="55" NAME ="q" />
<INPUT TYPE="submit" NAME="submit" VALUE="SEARCH" />
</FORM>

[Weedpacket]

 $numrows=mysql_num_rows($numresults); 

Don't you mean $result instead of $numresults?