It's definitely something with the php interface. If I do anything at the command line, with MySQL, it works fine.

I attached the phpinfo() output. I'm not sure how I'm supposed to directly use that to figure out if the characters are being lost by PHP.

I did notice however, that after an attempted query with phpmyadmin, the script will display the SQL used, which is lacking the characters as well. So it seems that the script isn't getting the proper data.

I tried things out in IE 5.5, Opera 5, and Netscape 6, and they all do it, so it's not the browser dropping stuff.

-Micah




At 03:20 PM 9/23/2002 -0700, you wrote:
Use phpinfo(); to figure out if the missing four characters are being
lost in PHP or when you're doing the INSERT or UPDATE into mysql.

Also try doing the INSERT/UPDATE via the mysql command line.

Michael


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Micah Stevens
Sent: Monday, September 23, 2002 3:00 PM
To: dbmail@dbmail.org
Subject: [Dbmail] Dropping characters.

I know this isn't directly related to dbmail, but the people on the
php-db
mailing list aren't being too helpful and I was wondering if anyone here

had any ideas.

I've been having an issue where php will drop the first four characters
from a POSTed form field when inserting/updating information in MySQL. I

noticed while trying to add users to the DBMail database, and I can't
figure out what's going on. At first I thought it might be my script,
but
if I do things manually with a tool like PHPMyadmin it drops the
characters
too.

I started noticing the problem last week after I upgraded to php 4.2.3.

It's always four characters, and it never happens when I have less than
four fields in a form.

I'm running RH 7.2, MySQL 3.23, and PHP 4.2.3.

Any help, or ideas of where to look for problems would be appreciated.

Thank you,
-Micah

_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to