i think the best is tou write your one. i did and it wasn't too hard.
try this:
first do a search form
<table width=720 border="0" cellpadding="0" cellspacing="0" align="center" class="bodysmall" height="10">
<tr valign="middle">
<td width="50%" valign="middle" align="center"> <form name="name" method="post" action="author.php" class="bodysmall">Search by Author:
<input type="text" name="name" size="20" maxlength="40" style="border:1px solid black" class="bodysmall">
<input type="submit" name="Submit" value="Search" class="bodysmall" style="border:1px solid black; bgcolor:#EFEFEF">
</form
</table>
and then in the author.php page do a simple query..
$myvar = $_POST['name']; //get the post variable
$result = mysql_query("SELECT * FROM `letras` WHERE `autor` LIKE '%$myvar%' ORDER BY disco");
if(!$result || !mysql_num_rows($result)) {
echo "<table width=\"100%\" border=\"0\" class='body'><tr><td>La busqueda no ha producido ningun resultado.</td></tr></table>";
} else {
print("<table width=\"100%\" border=\"0\" class='body'>");
print("<tr><td width='33%'>Autor</td><td width='33%'>Titulo</td><td width='34%'>Disco</td></tr>");
while($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("<tr><td>%s</td><td><a href=\"%s?id=%s\">%s</a></td><td>%s</td></tr>\n", $myrow['autor'], $PHP_SELF, $myrow['id'], $myrow['titulo'], $myrow['titulo']);
}
echo "</table>";
}
remeber that before you do the query you must connect to the database.
if you need any help tell me.
