Good tutorials on setting up a DB search from a web app?

[mgoldsmith]

Does anyone know some tutorials on coding a page so that it can run a select statement using input boxes and then return the results?

thanks

Max

[pinkcat_02]

check out the url below, there are more advanced ones on that site as well if you like to see search on that site.


http://www.4guysfromrolla.com/webtech/102499-1.shtml

[mgoldsmith]

Thanks, but not really what I'm looking for

I need a page that can construct a SQL select statement based on some input boxes and then return the results from the database to the page.

[pinkcat_02]

i have an example code of what you looking for that myself is using, the only difference is, it's getting the data from a drop down table rather than a textbox where you can easily change to a text box.

if u like i can email you the code that you can give it a go?

[whammy]

Actually I posted a pretty good basic example in this forum, awhile back... lemme see if I can find it...

[whammy]

Check out this:

http://www.codingforums.com/showthread.php?s=&threadid=12101&highlight=search+form

And this:

http://www.codingforums.com/showthread.php?s=&threadid=11843&highlight=search+form

Those should give you the basic ideas, of course you can make it as simple or complex as you want.