Good day to all,
can anyone tell me why my mysql do not support the "%"??What is happen?
Anyone can let me know how to edit the "query" statement (red in color)?
---------------------------------------------------------------
error message shown:
cannot execute sql becauseYou 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">
<br />
<input type=submit value=Search>
</form>
</body>
</html>
------------------------------------------------------------
//result.php
<html>
<head>
<title>New Page 1</title>
</head>
<body>
<?php
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchterm'];
$query="SELECT * FROM book
where " . $searchtype . " like % " . $searchterm . "%";
$connection=mysql_connect("localhost","root","") or die("cannot connect!");
mysql_select_db("kelly") or die("cannot select db!");
$result=mysql_query($query) or die("cannot execute sql because".mysql_error());
if(mysql_num_rows($result)>0)
{
echo"<table>";
echo"<td>ISBN</td>";
echo"<td>TITLE</td>";
echo"</tr>";
while($row=mysql_fetch_assoc($result))
{
echo"<tr>";
echo"<td>".$row['isbn']."</td>";
echo"<td>".$row['title']."</td>";
echo"</tr>";
}
echo"</table>";
}
else
{echo"No data found!";
}
mysql_close($connection);
?>
</body>
</html>
------------------------------------------------//(end)
From,
UTAR student
MALAYSIA
Problem in php4 Vs Mysql4(Select query unsupport"%")
Linear Mode
