php-windows Digest 20 Aug 2004 19:27:06 -0000 Issue 2367
Topics (messages 24436 through 24436):
PHP5.01 and HTML
24436 by: Chuck
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin 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
--- End Message ---
