[PHP-DB] Different character sets

2004-01-20 Thread Christine Clerc
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 :

Re: [PHP-DB] Different character sets

2004-01-20 Thread Muhammed Mamedov
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 pages

[PHP-DB] Unsubscribe (mailign lsits in general) question...

2004-01-20 Thread Tristan . Pretty
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

RE: [PHP-DB] Unsubscribe (mailign lsits in general) question...

2004-01-20 Thread Hutchins, Richard
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

Re: [PHP-DB] Unsubscribe (mailign lsits in general) question...

2004-01-20 Thread CPT John W. Holmes
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

Re: [PHP-DB] Unsubscribe (mailign lsits in general) question...

2004-01-20 Thread Tristan . Pretty
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...

Re: [PHP-DB] breaking apart data

2004-01-20 Thread CPT John W. Holmes
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 asdfierw

Re: [PHP-DB] breaking apart data

2004-01-20 Thread Larry R. Sieting
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 this

Re: [PHP-DB] breaking apart data

2004-01-20 Thread Ricardo Lopes
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 wanting

Re: [PHP-DB] breaking apart data

2004-01-20 Thread Chris Boget
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 script language=php function bulletElements( $arrElement, $key ) { echo 'li' . $arrElement . '/li'; } $str = asdf

RE: [PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

2004-01-20 Thread William Cheung
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]

[PHP-DB] PHP 4.3.4 ADODB Oracle 9.2

2004-01-20 Thread William Cheung
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.

Re: [PHP-DB] PHP 4.3.4 ADODB Oracle 9.2

2004-01-20 Thread Christopher Jones
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

[PHP-DB] Re: Subject: Different character sets

2004-01-20 Thread Neil Smth
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

Re: [PHP-DB] breaking apart data

2004-01-20 Thread Larry R. Sieting
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 css

[PHP-DB] Update problems

2004-01-20 Thread Kermit Short
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

RE: [PHP-DB] Update problems

2004-01-20 Thread Peter Lovatt
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

RE: [PHP-DB] Update problems

2004-01-20 Thread Paul Miller
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

[PHP-DB] What am I doing wrong with pg_copy_from ?

2004-01-20 Thread James Long
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