note 96008 added to book.mssql

I had the same problem reported by Exidas and decided to optimize and simplify his function. Enjoy: <?php $sql="SELECT * FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog=c.table_catalog AND t.table_schema=c.table_schema AND t.table_name=c.table_name ORDER BY t.table_name"; $rs=mssql_query($sql); $tabela=""; while($r=mssql_fetch_array($rs)){ if($r['TABLE_NAME']!=$tabela){ $tabela=$r['TABLE_NAME']; echo '<h2>'.$tabela.'</h2>'; } echo $r['COLUMN_NAME'].' - '.$r['DATA_TYPE'].'<br>'; } ?> ---- Server IP: 69.147.83.197 Probable Submitter: 201.22.86.135 ---- Manual Page -- http://www.php.net/manual/en/book.mssql.php Edit -- https://master.php.net/note/edit/96008 Del: integrated -- https://master.php.net/note/delete/96008/integrated Del: useless -- https://master.php.net/note/delete/96008/useless Del: bad code -- https://master.php.net/note/delete/96008/bad+code Del: spam -- https://master.php.net/note/delete/96008/spam Del: non-english -- https://master.php.net/note/delete/96008/non-english Del: in docs -- https://master.php.net/note/delete/96008/in+docs Del: other reasons-- https://master.php.net/note/delete/96008 Reject -- https://master.php.net/note/reject/96008 Search -- https://master.php.net/manage/user-notes.php