Code for combined search

[ruds]

Can any one help me by telling how to implement a code for combined
search .My problem is I want to search database using cominatio search
for eg: I want to search by user as well as date in one go .What should
I do?
Any suggestions?

 

[Roedy Green]

Can any one help me by telling how to implement a code for combined
search .My problem is I want to search database using cominatio search
for eg: I want to search by user as well as date in one go .What should
I do?
Any suggestions?

this is an SQL database? See http://mindprod.com/jgloss/sql.html
for some sample queries with a WHERE clause.

SELECT confirm, ordertimestamp
FROM orders
WHERE confirm < 2000 AND vendorid = 1234
ORDER BY confirm DESC