Error in SQL syntax!

sullen · #1 12-18-2006, 03:17 AM

Hello friends,
I use mysql servers and clients 4.0.14b and php 4.4.4 but I am facing a coding problem,

The error message shown is:

Cannot execute sql because you have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '% %' at line 1

-----------------------------------------------------------
<html>
<head>
</head>
<body>
<form action=result.php method=post>
Choose Search Type:<br />
<select name="searchtype">
<option value="author">Author</option>
<option value="title">Title</option>
<option value="isbn">ISBN</option>
</select>
<br />
Enter Search Term:
<br />
<input type=text name="searchterm">
<b -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

inder · #2 12-18-2006, 03:19 AM

Try the following:
$query="SELECT * FROM book where " . $searchtype ." like '%" . $searchterm . "%'";

Hope it will help you! Good Luck! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --