RSS

Re: searching multiple fields

Please support our PHP advertiser: Lunarpages PHP Web Hosting

searching multiple fields

•

Join Date: Jun 2004

Posts: 11

Reputation: charter is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

charter

Offline

Newbie Poster

Re: searching multiple fields

Jun 20th, 2004

•

Originally Posted by Ragnarok

The SQL would look something like this:
Help with Code Tags

(Toggle Plain Text)
"SELECT * FROM table WHERE wkno LIKE '%".$_POST['searchterm']."%' OR year LIKE '%".$_POST['searchterm']."%'"
"SELECT * FROM table WHERE wkno LIKE '%".$_POST['searchterm']."%' OR year LIKE '%".$_POST['searchterm']."%'"

Sorry but this isn't what I am looking for.

I want a page with 2 search boxes (the code I gave was for 1 box).

The data base includes 2 fields 1 for wk no and 1 for year.

I want to search in 1 box for the wk no and to search in the other box for the year.

Then for the result to match the wk no. and the year.

This means having 2 search box forms on one page but one button to search for the criteria

DaniWeb Home > Forums > Web Development > PHP > searching multiple fields

Re: searching multiple fields

searching multiple fields

Re: searching multiple fields