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.