RE: [PHP-WIN] PHP and HTML
| From: | Gryffyn, Trevor | Date: | Fri, 20 Aug 2004 19:45:22 +0000 |
| Subject: | RE: [PHP-WIN] PHP and HTML | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-24438@lists.php.net to get a copy of this message | ||
I got it the first time, so guess it went through.
I don't remember if it needs to be this strict or not, but I'd do it
this way:
Echo "<OPTION value=$Name>$Name</OPTION>";
Doensn't look like you're ECHOing or otherwise outputting the OPTION tag
and I usually include a "value=" with my options.
No need to use the "." to concatenate a simple variable like that, if
the "$Name" is in the quotes, it'll get interpreted.
Hope this helps!
-TG
> -----Original Message-----
> From: Chuck [mailto:cmorris@threesource.tv]
> Sent: Friday, August 20, 2004 3:41 PM
> To: php-windows@lists.php.net
> Subject: [PHP-WIN] PHP and HTML
>
>
> Sorry if this was posted twice. I don't think the first one
> went thru.
>
> 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
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>