Listing All Rows and Fields in a Table

Sun Oct 26, 2008 7:25 pm

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>