ListBox
| From: | sam rumaizan | Date: | Sat, 05 May 2007 05:48:56 +0000 |
| Subject: | ListBox | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27825@lists.php.net to get a copy of this message | ||
The code is fine. But I have one problem, when the ListBox display the data it gives me extra empty
lines. How can I get rid of these lines?
< -------- ListBox Code
----------------------------------------------------------------------------------->
echo"<table border='1' cellspacing='1' cellpadding='3'
bordercolor= 'CDCB98'>";
echo'<form name="myform" method="post"
action="sfd.php">';
$result = mysql_query('select * from lo_data');
echo"<tr bgcolor='CDCB98'>";
echo "<td>" ;
echo"<select NAME='Cat' onchange='resubmit()'>";
echo"<option value='NULL'>Select Search Item</option>";
$i=0;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($line as $col) {
$field=mysql_field_name($result,$i);
$array[$field] = $col;
echo"<OPTION value='$field'";
echo ">$field</OPTION>";
$i++;
}
}
echo "</SELECT>";
echo "</td>";
echo "</form>";
---------------------------------
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.