Show Records by multi Columns in Rows

There are simply to show data records in table rows, just one record by one table row but sometime you need to show data records more than one record in one row. This tutorial show you how can to show your data records in the table with three columns and make multi-rows automatically with while loop.

This tutorial require 1 PHP file and 1 table of mySQL database.

1. show_multi_columns.php
2. Database "tutorial" and table "name_list" with 2 fields: id(auto_increment), name(varchar, 50) and put some records about 20 - 30 records into this table. (directly by phpMyAdmin)

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 174 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 175 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 175 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 178 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 178 <table border="1"> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm on line 182 </table> </body> </html> <a target="_blank" href="http://www.phpfreecode.com/">PHP Free Code</a>

Show Records by multi Columns in Rows Next Code