note 97820 deleted from book.mssql by danbrown
| From: | danbrown@php.net | Date: | Mon, 10 May 2010 14:51:45 +0000 |
| Subject: | note 97820 deleted from book.mssql by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-169123@lists.php.net to get a copy of this message | ||
Note Submitter: Anonymous
----
Better use this version to get all columns in the right order
<?php
$all = MSSQL_Query("select TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS order by
TABLE_NAME, ORDINAL_POSITION");
$tables = array();
$columns = array();
while($fet_tbl = MSSQL_Fetch_Assoc($all)) { // PUSH ALL TABLES AND COLUMNS INTO THE ARRAY
$tables[] = $fet_tbl[TABLE_NAME];
$columns[] = $fet_tbl[COLUMN_NAME];
}
$sltml = array_count_values($tables); // HOW MANY COLUMNS ARE IN THE TABLE
$i2=0;
foreach($sltml as $table_name => $id) {
echo "<h2>". $table_name ." (". $id .")</h2><ol>";
for($i = 0; $i <= $id-1; $i++) {
echo "<li>". $columns[$i2] ."</li>";
$i2++;
}
echo"</ol>";
}
?>