note 16189 added to ref.mysql

// gen_sel_list() by Jeroen van Dolder - DRNET www.drnet.nl // Use this function to HTML-format contents of a database column // I have got a lib. of these functions, if you like them contact me function gen_sel_list ($preBody,$preSection,$section,$postSection, $postBody,$sIPServer,$oDataBase,$sTable,$sUser,$sPass) { mysql_connect($sIPServer,$sUser,$sPass); $oResult = mysql_db_query($oDataBase,"select distinct ".$section." from ".$sTable); echo $preBody; while($oRow = mysql_fetch_array($oResult)) { echo $preSection; echo $oRow[$section]; echo $postSection; } echo $postBody; mysql_free_result($oResult); } //Run like this: //---------------------------------------------------- //gen_sel_list ('<SELECT>','<OPTION>','my_column','</OPTION>','</SELECT>', // 'my_ipadress','my_database','my_table','user','pass') //<SELECT><OPTION>RED</OPTION><OPTION>BLUE</OPTION><OPTION>GREEN</OPTION></SELECT> //---------------------------------------------------- //gen_sel_list ('<OL>','<LI>','my_column','</LI>','</OL>','127.0.0.1', // 'my_database','my_table','guest','guest') //<OL><LI>Item 1</LI><LI>Item 2</LI><LI>Item 3</LI></OL> //---------------------------------------------------- //gen_sel_list ('<myXML-tag1>','<myXML-tag2>','my_column','</myXML-tag2>', // '</myXML-tag1>','127.0.0.1','my_database','my_table','guest','guest') //<myXML-tag1><myXML-tag2>Item 1</myXML-tag2><myXML-tag2>Item 2 //</myXML-tag2><myXML-tag2>Item 3</myXML-tag2></myXML-tag1> -- http://www.php.net/manual/en/ref.mysql.php http://master.php.net/manage/user-notes.php?action=edit+16189 http://master.php.net/manage/user-notes.php?action=delete+16189 http://master.php.net/manage/user-notes.php?action=reject+16189