Perhaps the most popular way to lay out database results is using HTML tables where each row in the database is a row in the table, and each column in the database is a column in the table. In order to give you a head start in this common task, here's an example of table printing in action. The SQL schema used is this:
CREATE TABLE dogbreeds (ID INT AUTO_INCREMENT PRIMARY KEY, Name CHAR(50), Size CHAR(10), Info CHAR(50));
Go ahead and add your own fields to that to fill it up, then create a script with the following code:
As you can see, it is the same "iterating through mysql_fetch_assoc() " approach we've used previously, but now we're using it to create an HTML table row by row - as you can see from the screenshot below, it works very well.
Copyright 2012 Future Publishing Limited (company
registered number 2008885), a company registered
in England and Wales whose registered office is at