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
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
I'm trying
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 quotes around the name
FirstName=$fname
otherwise it takes the value of $fname to be aa field name
HTH
Peter
If I have the right-end of the stick then this is what you want:
$dropdown =
form method=\post\ action=\somescript.php\
select name=\yourselect\
option value=\selected\--choose one--/option;
while($row = mysql_fetch_array($result)) {
$var = $row['yourcolumn'];
$dropdown .= option
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
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