Mysql result all - PHP Best Codes

PHP Code:

Get Free PHP codes and scripts. Use PHP script and easily with HTML help and samples. Learn PHP source code, function, forms, website, forum, design.

Link Us:

Just put this code to your pages and you will have our logo in your site! This brings traffic to your website.

Favorite Us!

We update weekly!

Visitors:

Online Users:

PHP Code 61

Mysql result all Next Code

There is a PHP function named odbc_result_all which returns the query results in a table. I have frequently found it useful to have the same function for MySQL queries. This function will create a table populated with the data as well as the field names. 
Usage: 
 

$result = dbQuery("SELECT * FROM tableName"); 
mysql_result_all($result); 

 
I am not a PHP master, so any improvement suggestions are welcome.

function mysql_result_all($result) { $nrow = 0; echo("<table border=1 cellpadding=5 cellspacing=0><tr><th>Row</th>\n"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<th>".mysql_field_name($result, $i)."</th>\n"); echo("</tr>\n"); while($row = mysql_fetch_array($result)) { echo("<tr><td>$nrow</td>"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<td>$row[$i]</td>\n"); echo("</tr>\n"); $nrow++; } echo("</table>\n"); } <a target="_blank" href="http://www.phpfreecode.com/">PHP Free Code</a>

Preview:
Your browser does not support inline frames or is currently configured not to display inline frames.

Go to Homepage Contact Us

By Krishna Eydat & Mahmood Bina

Download free PHP codes and scripts, help with forums, samples and examples of a professional website with PHP design, you can use Javascript codes and HTML scripts and tangs. PHP tutorials and lessons step by step, use PHP free script ,script ,source ,code generator ,sample code ,examples ,script code ,open source, free source ,forms ,code editor ,forum ,array ,function ,website codes ,include ,Web design, webmaster ,protect code , email , PHP forum codes, forum scripts , dynamic code, PHP helps