hi
i have a application were the user admin will select a key word from the drop down based on the dropdown selection....it should search all the rows in a particular table.the corresponding matching data should get displayed to the admin.
lydia21
9
Junior Poster
Recommended Answers
Jump to PostIf you're using MySql then you could set the storage engine to MyIsam and use the fulltextsearch capability. See the MySql docs for more info.
Jump to PostHe selects a keyword from the dropdown ?
Well, then, you can simply use,$query="select * from table where col like '%$value%'";
$value is the selected value of the dropdown.
All 8 Replies
pritaeas
2,149
¯\_(ツ)_/¯
Moderator
Featured Poster
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
lydia21
9
Junior Poster
ryan_vietnow
13
Posting Pro
lydia21
9
Junior Poster
nav33n
commented:
You have 68 posts and still you don't use [code] tags.That's bad.
+0
ryan_vietnow
13
Posting Pro
lydia21
9
Junior Poster
lydia21
9
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.