 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
Say you have the following database table: database name: db_business table name: tbl_clients --------------------------------------------------- |client_name|client_age|client_city |client_salary| --------------------------------------------------- |Bob | 42|Dubai | 12000| --------------------------------------------------- |Pinky | 18|Harare | 6000| --------------------------------------------------- |Susan | 23|Cape Town | 57000| --------------------------------------------------- |Brain | 102|Earth | 0| --------------------------------------------------- The following illustrates how to output the results in the following HTML table: ---------------------- |Bob |Pinky | |42 |18 | |Dubai |Harare | |12000 |6000 | ---------------------- |Susan |Brain | |23 |102 | |Cape Town |Earth | |57000 |0 | ---------------------- <?php mysql_connect("localhost","your_username","your_password"); $sql_client_details = "SELECT * FROM tbl_clients"; $sql_client_details_result = mysql_db_query("your_database",$sql_client_details); // desired columns in a table $num_cols = 2; // dummy variable to hold our loop count $while_count = 1; // number of items we need to output. this number is determined by the number of // records returned by our query $num_records = mysql_num_rows($sql_client_details_result); // start a new table row $new_row = 1; // count the number of <td>s we have so far in this row $td_count = 0; // I want to use colspan for the last row if it's incomplete. // Set this to any other value other than 1 if you do not want to span --UGLY-- $want_to_colspan = 1; // the total number of table rows we will end up having $num_rows = ceil($num_records / $num_cols); // number of rows we have so far $row_number = 0; print "<table border=\"1\">\n"; while ($client_details_array = mysql_fetch_array($sql_client_details_result)) { $client_name = $client_details_array["client_name"]; $client_age = $client_details_array["client_age"]; $client_city = $client_details_array["client_city"]; $client_salary = $client_details_array["client_salary"]; if °LžÏÈNžÏÐNžÏDÀ n=All+Categor>\n"; $new_row = 0; // don't start a new table row $row_number++; } if (($want_to_colspan == 1) && ($row_number == $num_rows) && ($while_count == $num_records)) { // we want to colspan the remaining table columns $num_cols_to_span = $num_cols - $td_count; print "<td colspan=\"$num_cols_to_span\">\n"; print "$client_name<br>\n"; print "$client_age<br>\n"; print "$client_city<br>\n"; print "$client_salary\n"; print "</td>\n"; $td_count++; // not necessary as this is the last row anyway } else { // just print print "<td>\n"; print "$client_name<br>\n"; print "$client_age<br>\n"; print "$client_city<br>\n"; print "$client_salary\n"; print "</td>\n"; $td_count++; } if ($td_count == $num_cols) { // close the table row since we have the required columns in one table row print "</tr>\n"; $new_row = 1; // we need to start a new row $td_count = 0; } $while_count++; } // HTML compliance and for Netscape && similar browsers' sake!! if (($num_records % $num_cols) != 0) { print "</tr>\n"; } print "</table>\n"; mysql_free_result($sql_client_details_result); ?> http://site.mweb.co.zw/users/kiri/php_multiple_columns.cfm | |||||
| Related Code Examples | |||||
