Hello! I'm new to the list. I'm learning php and PostgreSQL
basics.
I'm having a hard time finding a clean way to
retrieve a table row;
edit it;
write it back to the table;
Ideally, I'd like to read the row as an associative array, display
an html page that will allow the user to edit thoe ar
You might want to use single quotes
FirstName='$fname'
$sqlupdate="UPDATE UserInfo
SET ZNum='112763', FirstName='$fname', LastName='Short', TA='00',
Building='1197', Room='112', Div='FWO', Grp='IIM'
WHERE ZNum='112763'";
- Paul
-Original Mess
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 to
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
Thanks Chris... that worked great.
Guess I need to spend a _lot_ more time reading the manual.
At 11:28 AM 1/20/2004, Chris Boget wrote:
> duh (me)
> okay... I am wanting to wrap the lines of text in bullets and perform some
> text formatting on it (highlight, bold, underling, etc..) using cs
Regarding carriage returns showing up - this is simple : Look at any HTML
page source.
You will see it is littered with many carriage returns, long areas with
many spaces and so on. In HTML, the spaces (more than one) are condensed
into one space, and carriage returns are not significant sas th
William Cheung wrote:
All the system errors are solved. However, the query seems not returning
any rows. I got undefined index error on any query returns.
Am I hitting the brick wall? Do PHP and ADODB work with Oracle 9.2? Are
there anyone know the answer?
I am using Windows 2K, IIS and Orac
Hi,
All the system errors are solved. However,
the query seems not returning any rows. I got undefined index error on any
query returns.
Am I hitting the brick wall? Do PHP and ADODB
work with Oracle 9.2? Are there anyone know the answer?
I am using Windows 2K, IIS and Oracle.
W
Thanks,
I found out that the TNS name in ADODB is wrong. After I fixed it, the error
gone.
William Cheung B.Sc, MCSE, MCDBA
Databyte Corp.
-Original Message-
From: Christopher Jones [mailto:[EMAIL PROTECTED]
Sent: January 19, 2004 12:14 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sub
> duh (me)
> okay... I am wanting to wrap the lines of text in bullets and perform some
> text formatting on it (highlight, bold, underling, etc..) using css classes
function bulletElements( &$arrElement, $key ) {
echo '' . $arrElement . '';
}
$str = "asdf asdf sadl jf
You probably have more luck in a regular expression mailing list. Just an
opinion.
- Original Message -
From: "Larry R. Sieting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 20, 2004 4:17 PM
Subject: Re: [PHP-DB] breaking apart data
> duh (me)
>
> okay... I am w
duh (me)
okay... I am wanting to wrap the lines of text in bullets and perform some
text formatting on it (highlight, bold, underling, etc..) using css classes
At 11:12 AM 1/20/2004, you wrote:
From: "Larry R. Sieting" <[EMAIL PROTECTED]>
> what would be the most efficient way to rework th
From: "Larry R. Sieting" <[EMAIL PROTECTED]>
> what would be the most efficient way to rework this data in to what I am
> after
>
> stored text:
> asdf asdf sadl jf lsakdjf a \r\n asdfierw aweiufasd asiuwr \r\n
> asdhfauiweuhrahsd \r\n
>
> displays text as:
> asdf asdf sadl jf lsakdjf a
> asdf
HEllo,
I have some data stored in a database (mysql) that I need to break
apart. When I display it, I use the nl2br function.. works fine...
but I want to do some formatting to each line of text and need to break it
apart.
when I look at the raw data, it has the escape sequence \r\n (return\l
Sorry, forgot to put the[OT] bit in the subject line...
"CPT John W. Holmes" <[EMAIL PROTECTED]>
20/01/2004 14:27
Please respond to
"CPT John W. Holmes" <[EMAIL PROTECTED]>
To
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc
Subject
Re: [PHP-DB] Unsubscribe (mailign lsits in general) question.
From: "Christine Clerc" <[EMAIL PROTECTED]>
> My pages collect short texts from different languages through HTML
> forms. The texts are stored in a MySQL database. Then, they are used
> in HTML pages.
>
> Problem 1 : the carriage returns don't show back up.
Yes they do. Look at the HTML source of
What's this got to do with databases (PHP-DB list)? It's barely related to
PHP to begin with. Think about where your sending your messages before you
click the button.
---John Holmes...
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 20, 2004
Tris,
Here's what I found on infoworld.com in a very limited search (dated
1/12/04). There is info in there that should provide you with other avenues
of research to clarify your company's responsibility. Here is a relevant
excerpt:
"CAN-SPAM [went into effect Jan 1., 2004] requires that spam e-m
I've been told by my boss, that the law has changed in relation to 'Opt
out' options on mailing lists etc...
she tells me that I have to now change all my forms to conform.
She claims that now, each time the user must click the 'remain subscribed'
link, or we have to remove them from our mailing
Try Unicode (UTF-8) encoding...
Make charset=utf-8 an your pages
Muhammed Mamedov
turkmenweb.com
- Original Message -
From: "Christine Clerc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 20, 2004 3:59 PM
Subject: [PHP-DB] Different character sets
> Hi,
>
> My
Hi,
My pages collect short texts from different languages through HTML
forms. The texts are stored in a MySQL database. Then, they are used
in HTML pages.
Problem 1 : the carriage returns don't show back up.
Problem 2 : The character above chr128 are not coded properly (obviously)
Problem 3 : w
21 matches
Mail list logo
