PHP 5.01 and HTML
| From: | Chuck | Date: | Fri, 20 Aug 2004 19:41:26 +0000 |
| Subject: | PHP 5.01 and HTML | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-194366@lists.php.net to get a copy of this message | ||
Hello everyone. I have the following script that creates a listbox. My box
appears, but I can't get any data into it. Can someone let me know what I'm
doing wrong.
<SELECT name="Company List" multiple size="8">
<?php
$db = new COM("ADODB.Connection");
$dsn = "DRIVER=SQL Server; SERVER=D63WV941;UID=sa;PWD=sa;
DATABASE=BINDER";
$db->Open($dsn);
$rs = $db->Execute("SELECT * from company");
while (!$rs->EOF)
{
$Name = $rs->Fields['Name']->Value;
// This doesn't get listed.
"<OPTION>".$Name;
$rs->MoveNext();
}
?>
</SELECT>
I appreciate the help,
Chuck