\n\n"; // jargon/list (K) 1999 drt // // Litle Hack to show a index of our Jargon Database. // // Expects a mysql-Table a la: // // # // # Table structure for table 'lex' // # // CREATE TABLE lex ( // name varchar(254) DEFAULT '' NOT NULL, // gender varchar(254) DEFAULT '' NOT NULL, // origin varchar(254) DEFAULT '' NOT NULL, // pronounciation varchar(254) DEFAULT '' NOT NULL, // aka varchar(254) DEFAULT '' NOT NULL, // text text NOT NULL, // changed char(3) DEFAULT 'yes' NOT NULL, // PRIMARY KEY (name), // KEY aka (aka) // ); // // // $Log: list.php3,v $ // Revision 1.2 1999/03/14 22:18:56 drt // Some Beautifying of the Output // // Revision 1.1 1999/03/14 21:54:30 drt // Initial revision // // require( "shared.inc"); commonHeader( "Jargoninterface - Index"); $sh_emailcontact = 'drt@koeln.ccc.de'; $sh_author = 'Doobee R. Tzeck'; $sh_copyrightnotice = "The Jargoninterface, " . $sh_copyrightnotice; $me = ''; echo "

This is alpha software - so it looks sometimes a bit strange.
See http://www.tuxedo.org/jargon for the real thing.

\n"; mysql_pconnect("localhost","httpd","EgAl"); // print a-z $end = ord('Z'); echo "

\n"; echo "| \n"; for ($i=ord('A'); $i<=$end; $i++) { echo "". chr($i). " | \n"; } echo "

\n"; echo "

Index

\n"; $list2 = $list . 'ZZZZZ'; $sect = '#misc'; $result = mysql_db_query("jargon","SELECT * FROM lex WHERE name BETWEEN '$list' AND '$list2' ORDER BY name ASC"); echo "

#misc

\n"; while($row = mysql_fetch_array($result)) { $sectN = strtoupper(substr($row[name], 0, 1)); if( !($sect == $sectN)) { if($sectN >= "A") { $sect = $sectN; echo "

$sect

\n"; } else { if($notfirst) { echo ", "; } $notfirst = true; } } else { echo ", "; } echo "$row[name]\n"; } mysql_free_result($result); commonFooter(); ?>