Listing All Rows and Fields in a Table

Listing all rows and fields in a table

Code:

<html>
<head>
<title>Listing all rows and fields in a table</title>
</head>
<body>
<?php
$user = "user";
$pass = "password";
$db = "userdb";
$link =  mysql_connect( "server", $user, $pass );

if ( ! $link ){
    die( "Couldn't connect to MySQL" );
}

mysql_select_db( $db, $link ) or die ( "Couldn't open $db: ".mysql_error() );
$result = mysql_query( "SELECT * FROM Employee" );

$num_rows = mysql_num_rows( $result );
print "There are currently $num_rows rows in the table<P>";
print "<table border=1>\n";

while ( $a_row = mysql_fetch_row( $result ) ){
    print "<tr>\n";
    foreach ( $a_row as $field )
        print "\t<td>$field</td>\n";
    print "</tr>\n";
}

print "</table>\n";
mysql_close( $link );
?>
</body>
</html>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Listing All Rows and Fields in a Table
Select odd rows from table -
different colors for table Even- Odd rows and Cells -
Multi colored table rows -
How to save a search fields...in Struts2.0 -
listing tag usage -
Clear specific form fields using JQuery -
Listing the Contents of a Directory -
Disable submit button until all form's fields are filled -
Listing elements using list components in J2me -
three rows frameset . -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com