note 16189 deleted from ref.mysql by jimw
| From: | jimw@php.net | Date: | Fri, 19 Oct 2001 18:08:49 +0000 |
| Subject: | note 16189 deleted from ref.mysql by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-19172@lists.php.net to get a copy of this message | ||
// 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>