Search multiple fields in a single table

[DSA_ADI]

I am trying to create a search facility for my website and need to be able to search multiple fields in a single table in MySQL, I am using dreamweaver, and my PHP and SQL knowledge is minimal, I don’t have a problem being able to search a single field in the database and displaying the results as dreamweaver generates the code for me.


The table I am trying to create the search for is called LEWISHAM and the fields within the table I need to search are; towna, townb, townc, postcodea, postcodeb, postcodec

If someone could please help me or point me in the right direction where I could learn more about searches or give me some tips to help that would be fantastic



Cheers


Peter

[leatherback]

something like this:

$query = "
select towna, townb, townc, postcodea, postcodeb, postcodec 
from LEWISHAM 
where
(
towna="$towna"
and
postcodea = "$postcodea")
or
(townb = "$townb"
 and postcodea = "$postcodea")"; 

However... I wonder WHY you have a towna and townb. Sounds like poor database design to me..

[Aybabtu]

$query = "select * from LEWISHAM where towna LIKE '%".$_GET['form_value']."%' or townb LIKE '%".$_GET['form_value']."%'"; 

You can keep adding or statements to search the other fields. Let me know if you need anything else. I am good at doing this but not at explaining it.

Aybabtu.

[Frido]

hello im new here.. Im trying to do search for multiple fields can you please help me?

Thanks

[Ashley Sheridan]

Frido, please try not to resurrect dead threads, this one was over 5 years old!

If you have a question, start a new thread. However, seeing that your question seems to be exactly the same, you could just try what has been posted as the answer for the OP.