asked on

Timyates: Modification for the all option

Hi,
I forgot to meantion, what if the user chooses all from the drop down list,
<option>All</option>
the whole table needs to be displayed , how do i do that and if the keyword or choose chosen is not inside the database, how to display
'Sorry no results are found..

ASKER CERTIFIED SOLUTION

TimYates

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TimYates

For everyone who doesn't know what this is about, it is to do with:

https://www.experts-exchange.com/questions/20788645/Search-by-keyword-skill-display-in-a-table.html

:-)

TimYates

Hope that sorted it! I'm off on holiday for 5 days!

Wheeee! Amsterdam, here I come ;-)

Jasbir21

ASKER

Hi,
the error i am getting is :
Executing Select skillid,skilldescription from skill WHERE ( skillid = '*' ) Sorry, no results found
when i choose the all option...

Jasbir21

ASKER

How do i ask it to search for other fields as well and not just skilldescription:

When i tried this , i got error

where += "( skilldescription LIKE '%" + word +"%',skillid LIKE '%" + word + "%')" ;

Thanks

Jasbir21

ASKER

Tim,
I have more questions and modifications concerning search by keyword, pls look at it at
https://www.experts-exchange.com/questions/20789534/Search-by-keyword.html

My problem is that what happens if values need to be chosen from different tables.