Hi All,
Being new to this forum,i am sorry if i put this thread in wrong category.
Here i need your help with my PHP +SQLserver code.
I have a textbox :Description where if i type something thats goes as a parameter to a stored procedure to fetch-filtered records based on parameter.
Now my description box also accepts wild cards - like Breck2 ,Breck ,( converted to % internally in php to feed to SQLserver.
Now my clients wants me to have descriptionbox abiliity to support boolean and/or.
eg input could be --> 'Breck2' and 'SATA' and('band' or 'random')
i parse the string in php ,but then 'or' wont give me 1 SQL for storedprocedure.
Moreover would i have to change my SP also .
My SP has the code -
select TQ_ID,TQ_NAME, TQ_DESCRIPTION, TQ_DATABASE, TQ_CREATOR, TQ_STARTED, TQ_FINISHED from dbname where isnull(TQ_DESCRIPTION,'''') like @p_Filter order by TQ_ID desc'
@p_Filter=is the Querystring passed/Description BOx
TQ_ID->ID value of description
Please suggest me how can i go ahead with it.