How do I retrieve data from the database & display it in HTML?
843840Nov 25 2002 — edited Jul 18 2006The database I am currently using is "mysql 3.23". I have a couple of simple tables, client & order. I would like to display in a single HTML page, the client and order information. Each table currently has an automatically generated ID, such as clientID and orderID. I have been able to insert the relevant information into the database, but I'm not sure exactly how to handle the displaying of this info back to the user in an HTML page. I have been using Apache Tomcat 4.03 and have been coding servlets to handle the information regarding the login and inserts. Now I would like to know the best solution for retrieving and displaying the data.
I will offer 5 Duke Dollars to the successful solution or at least, the best answer posted. Good luck! :)