Ok, better but stil not displayting properly.
Here is what my database field has:
import.csv'<">/\
Here is what is displaying:
import.csv'</\" size="40" maxlength="40" onkeypress="return noenter()">
It's choking on the double quote in the database field. Here is the code
snippet from my form:
<input type="text" name="email" value="<?php echo
display_database($db_accounting->Email); ?>" size="50"></td>
function display_database($value)
{
$value = htmlentities($value,ENT_COMPAT);
if (!get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
return $value;
}
-----Original Message-----
From: Stut [mailto:stuttle@xxxxxxxxx]
Sent: Friday, June 30, 2006 3:49 PM
To: Don
Cc: php list
Subject: Re: Displaying data from a MySLQ table
Don wrote:
> Hi Have have a varchar field in a MySQL database which contains the
> following
>
> 905.362.6000"l""s"'L'
>
> I am trying to display it on my web page in a <INPUT="TEXT"> field but
> all I see is:
>
> 905.362.6000
>
> I am wondering why the trailing characters do not display even though
> they are present in the database when I check using PhpMyAdmin. Please
help.
You need to run the value through htmlentities
(http://php.net/htmlentities).
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
