[Resolved] search for data from multiple fields

[sirTemplar]

hi all.

i have this form:

<form method="post" action="adds.php">
<p style="margin-top: 3; margin-bottom: 0"><font face="Verdana" size="2"><b>
<font color="#FFFFFF">Type City Name
<input type="text" name="FIELD_1" size="20">
</p>
</form>

this searches the database for the text filled by user on the "LOCALITA" field of the database and outputs the result.

what i want to do is to be able to search not only the "FIELD_1" field but also other fields on the database eg. "FIELD_2", "FIELD_3" etc.

how do i do this? thanks.

[LordShryku]

Well, if you know all the fields names, and it is all one table, you could easily format your query like

SELECT * FROM table
WHERE (field1 LIKE '%".$_POST['FIELD_1']."%'
       OR field2 LIKE '%".$_POST['FIELD_1']."%'
       OR field3 LIKE '%".$_POST['FIELD_1']."%')

[sirTemplar]

thanks, thanks, thanks pal!