Php Code: Show Records by multi Columns in Rows:Find Article

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)

<!-- This Script is from www.hawkee.com, found at www.phpfreecode.com--><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><br /><b>Warning</b>:  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 <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>174</b><br /><br /><b>Warning</b>:  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 <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>175</b><br /><br /><b>Warning</b>:  mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: A link to the server could not be established in <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>175</b><br /><br /><b>Warning</b>:  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 <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>178</b><br /><br /><b>Warning</b>:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>178</b><br /><table border="1"><br /><b>Warning</b>:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/home/content/k/k/r/kkr152/html/phpfreecode/show_records_by_multi_columns_in_rows.htm</b> on line <b>182</b><br /></table></body></html><br><font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/"><span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font>

Find Article

Monday, May 23, 2011

Php Code: Show Records by multi Columns in Rows

No comments:

Post a Comment