[SOLVED] search form shows all records
Posted: Sat Apr 26, 2008 5:31 am
i would like to have a search form for my books catalogue. i have this on my form
the action, search.php contains:
but when i do a word search on the input button of the form, the result prints all the data on the database not only the one i searched. any help please.
Code: Select all
<form method="post" action="search.php">
<font size="2" color="#FFFFFF">Book Title:</font></b><font color="#FFFFFF"><b>
</b>
<input name="Title" size="50" maxlength="50" style="font-weight: 700"></font></font></p>
<p style="margin-top: 5; margin-bottom: 0"> </p>
<p style="margin-top: 5; margin-bottom: 0"><font face="Verdana">
<b>
<font size="2" color="#FFFFFF">Book Author:</font></b><font color="#FFFFFF">
<input type="text" name="Author" size="50" maxlength="50"></font></font></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
Code: Select all
if ($Author == "")
{$Author = '%';}
if ($Title == "")
{$Title = '%';}
if ($Language == "")
{$Language = '%';}
if ($KeyWord == "")
{$KeyWord = '%';}
if ($CatNum == "")
{$CatNum = '%';}
$result = mysql_query ("SELECT * FROM catalogue
WHERE Title LIKE '%$Title%'
WHERE Author LIKE '%$Author%'
ORDER BY Title ASC, Author
",$conn);
$totalrows = mysql_num_rows($result);
if ($row = mysql_fetch_array($result)) {
do {
echo "<table bgcolor=#35669A border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=88% valign=top><b><font face=Verdana size=2 color=#0000FF></font></b></td>
<td bgcolor=#FFFFFF align=right width=12% valign=top><b>
<font face=Verdana size=1 color=#008000>code:</font></b>
<font face=Verdana size=1 color=#111111>{$row['CatNum']}
</td></font></table>";
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=674>";
echo "<tr><td bgcolor=#E1FFFF align=left valign=top width=571><b>
<font face=Verdana size=2 color=#800000><b>{$row['Title']},</b></font></td>";
echo "<tr><td align=left width=410 valign=top>
<font face=Verdana size=1 color=#0000FF><b>Author</b>
<font face=Verdana size=2 color=#000000>{$row['Author']} <b></font></td></tr></table>";
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?
echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<td align=left width=70% valign=top><font face=Verdana size=2 color=#FF0000><b>$totalrows</b></font><font face=Verdana size=2 color=#800000> record(s) found !</font></b></td></table>";
?>