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.
Thanks in advance
My code snippet is as follows:
<tr>
<td><font color="#FF0000"><b>Phone</b></font></td>
<td><input type="text" name="phone" value="<?PHP echo
query_database($db_account->Phone); ?>" size="25"></td>
</tr>
The query_database() function is my own and looks as follows:
// smart function for querying a MySQL database
function query_database($value)
{
// Stripslashes
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
// Quote if not a number or a numeric string
if (!is_numeric($value)) {
$value = mysql_real_escape_string($value);
}
return $value;
}
Thanks
_____
Don Proshetsky,
C.I.O.
LCL Navigation
This email and any files transmitted with it are strictly confidential and
may be privileged information. It is intended solely for the individual or
company to whom it is addressed and may not be copied, forwarded,
transmitted or otherwise distributed in any manner or form to any other
party. If you are not the intended recipient or the person responsible for
delivering this e-mail to the intended recipient, please indicate so and
return this email to the sender, after which, kindly delete it from your
computer as well as your email server. Without limitation, LCL Navigation
accepts no liability whatsoever and howsoever caused in connection with the
use of this email.
Are you on our eBLISS yet? It's simple yet amazing.
Just click here: http://www.lclnav.com/createaccount.html
to open a B2B account with us and do everything electronically 24/7.
Tel: 905-362-6000, Ext. 230
Fax: 905-362-6001
