Hi.

I want to generate a script where I can get related categories names in left/right panel........................as per the keyword entered by user.....

Can anyone help me on this as what the query should be............

I am using this..............

PHP Code:

select * from tblcat where category = '".$_REQUEST['get_searchword']."' 


But its showing on one keyword.........not all related with that.............

eg. if a user search for "Car Hire"

so that right/left panel shold show all the keywords having name Car + Hire in my data base.

Thanks in advance!

At a guess because I do not know how the data is stored to be precise about how to search it.

use wildcards and the LIKE operator

By the sound of it though, your table schema has been badly designed from the outset.

AND

NEVER EVER use direct user input values in a query. ALWAY ALWAYS sanitise them first to reduce the risk from SQL injection attacks.

Thanks for your reply chrishirst,

You are right................I am a newbie..............that's why making these silly mistakes.............and silly question......................but still I'd like to know how to sanitise user input values...........if you don't mind.......

BTW..............Thanks for your consideration......

http://www.webmaster-talk.com/php-fo...njections.html

Read this thread, it will explain how to filter the parameters and prevent sql injection:
http://www.webmaster-talk.com/php-fo...injection.html

Edit: Baah, Chris beats me (again) on the finish line...