searching form

[hookit]

Hi,

 

I have a bd with the following fields:

 

Id, state, town, address, day

 

Primary key: id

 

Each field, except id, should has a text field in the php form.

 

Blank inputs are allowed in the form.

 

The search should return the registries that match the inputs in the search. Combining 1 or 2 or 3 fields  or alltogether.

 

Can it be done with php?,  cause i have been told in a Mysql forum that is better done with php.

 

Thanks.

[Maq]

Can it be done with php?,

 

Yes.  What part are you having trouble with?  I'm not sure exactly what you're trying to ask because I don't see any other questions...

 

cause i have been told in a Mysql forum that is better done with php.

 

As opposed to?

[phporcaffeine]

SELECT * WHERE state LIKE '%" . $_POST['state'] . "%' AND town LIKE '%" . $_POST['town'] . "%', address LIKE '%" . $_POST['address'] . "%' AND day LIKE '%" . $_POST['day'] . "%' .... etc

 

Something like that?

[jarvis]

Hi hookit,

 

Are you trying to add data into the table but you want to check whether those fields are already used to prevent duplicate entries

Each field, except id, should has a text field in the php form.

or are youyou trying to search those fields?

search should return the registries that match the inputs in the search

[hookit]

Hi Jarvis

 

Im trying to make a search.

 

thanks