M
Mohammad S Khan
What is the best way of constructing a query realtime . I am thinking
along the lines of a screen with multiple combo boxes and text fields
that provide the user with options to select. After he is is done with
the selection a search query that would effectively span multiple
tables in the database to show the results.
I am having problems with 1) Efficient way of constructing the query ?
2) how to decide which columns to display in the result
i am using mySQL as the db ...any help appreciated .. thanks
along the lines of a screen with multiple combo boxes and text fields
that provide the user with options to select. After he is is done with
the selection a search query that would effectively span multiple
tables in the database to show the results.
I am having problems with 1) Efficient way of constructing the query ?
2) how to decide which columns to display in the result
i am using mySQL as the db ...any help appreciated .. thanks