Essentially, what you want to have happen is to have people call your script through their web browsers, your web server runs it, and the script logs in to your SQL server, submits whatever queries it needs to get the information, does something with it, and outputs it to stdout. Then, the web server takes the script's stdout, and sends it back to the web browser that called it. In theory you could have your script output the data in whatever form you wanted. I tried at work to have it output XML, and have a static XSL sheet on my server. Unfortunately, my boss uses Safari web browser, and that won't do client-side XML/XSLT parsing. I've even been able to dynamically generate images from database data using a setup like this. (Hey, I thought it was pretty cool.)
Keep the list posted so we can help you out.
Lloyd Brown
Ryan Bowman wrote:
So I'm in the process of learning SQL. Isn't there a way to dynamically build a web page from an sql database? Where would be a could place to learn this? I've been looking around but can't seem to find anything.
---- Ryan Bowman
I can feel the walls closing in on me, the door at the end of the tunnel is far too small... - Closing In 2.0 - Don't Be Afraid - insoc.org ---
_____________________________________________________________ Linux.Net -->Open Source to everyone Powered by Linare Corporation http://www.linare.com/
____________________
BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
____________________
BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
