i hv used one textbox for the search.....
but i am now trouble that how i identify that user hv entered only firstname or firstname and lastname or firstname ,lastname and country or firstname ,lastname and city or firstname ,lastname and state or firstname ,lastname, city ,state and country...
or he had entered the emailid ....
here i hv only one textbox which takes the value anyone who want to search...........
how can differentiate them from each other and can search the desired result..........
here my problem is also that i hv to show the result of search in another page so i hv to pass the entered value of the textbox as querystring.........
but how to divide the entered text so that it can be pass with querystring....
i want to make search like orkut search.......
try to solve my problem........
thanks
try to solve my problem........
thanks
CrishPosted Jun 19, 2010, 2:24 AM
select * from tablename where firstname like '@vartxtname%' or lastname like '@lastname%' or
country like '@country%'......
thanks