Read list of tables from database=".$db.", with user=".$un. ".
"; } if($host ==""){ $db_host = "localhost"; }else{ $db_host = $host; } $db_user = $un; $db_pwd = $pass; $db_name = $db; mysql_connect($db_host, $db_user, $db_pwd); mysql_select_db($db_name); ?>Field: | Type: | Null: | Key: | Default: | Extra: | "; $field = Array(); $type = Array(); $null = Array(); $keys = Array(); $default = Array(); $extra = Array(); while($row = mysql_fetch_array($query,MYSQL_ASSOC)) { foreach($row as $key =>$value){ if($key == "Field"){ $field[] = $value; }elseif($key == "Type"){ $type[] = $value; }elseif($key == "Null"){ $null[] = $value; }elseif($key == "Key"){ $keys[] = $value; }elseif($key == "Default"){ $default[] = $value; }else{ $extra[] = $value; } } } // display data for($i = 0;$i< count($field);$i++){ echo "
".$field[$i]." | ".$type[$i]." | ".$null[$i]." | ".$keys[$i]." | ".$default[$i]." | ".$extra[$i]." |
".$key.":".$nt." | "; $bold =1; }else{ echo "".$key.":".$nt." | "; } } // pad table $count = 3 -$count; for($i=0; $i < $count;$i++){ echo ""; } echo " | |||
"; foreach($row as $key =>$value){ echo $value; } echo " |