hi
i got to have data from mysql database to drop down menues in html how do i
do that?
I can´t get any data to my drop down menues...
thanks to anyone who can do this...
ns
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands
I'm trying to update a record in a MSSQL database. When I execute the
following code on an IIS5 webserver, I get an error message that says:
PHP Warning: odbc_do(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid column name 'Tom'., SQL state S0022 in SQLExecDirect in
E:\web\php
on 4/26/01 11:16 AM, ns ([EMAIL PROTECTED]) wrote:
> hi
> i got to have data from mysql database to drop down menues in html how do i
> do that?
> I can´t get any data to my drop down menues...
You need to run a query, something like:
SELECT DISTINCT from TABLE where SOMETHING
and they run a w
If I have the right-end of the stick then this is what you want:
$dropdown = "
--choose one--";
while($row = mysql_fetch_array($result)) {
$var = $row['yourcolumn'];
$dropdown .= "$var";
}//end while loop
$dropdown .= "";
Just replace the name of the column 'yourcolumn' and
you need quotes around the name
FirstName="$fname"
otherwise it takes the value of $fname to be aa field name
HTH
Peter
-Original Message-
From: Kermit Short [mailto:[EMAIL PROTECTED]
Sent: 20 January 2004 22:28
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update problems
x27;FWO', Grp='IIM'
WHERE ZNum='112763'";
- Paul
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 5:17 PM
To: Kermit Short; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update problems
you need quote