I made the following simple search form:
<form method="post" action="result.php3">
<input type="text" name="search" size=25 maxlength=25>
<input type="Submit" name="Submit" value="Submit">
</form>
and saved it as an HTML.
As you can see it calls up the following PHP file
called RESULT.PHP3
The part where it USES the variable "search" is:
$result = mysql_query("SELECT * FROM items WHERE id LIKE '%$search%'",$db);
Thats nice but it only searches the ID field in my MYSQL database as you can see.
My question is:
How do I search the entire TABLE and NOT just fields in my table?
