[PHP] RE: (SCL: 5) [PHP] query problem.

2006-01-24 Thread Duffy, Scott E 
Viewing in browser? If so view source.

-Original Message-
From: Angelo Zanetti [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 25, 2006 7:01 AM
To: PHP List
Subject: (SCL: 5) [PHP] query problem.

Hi guys.

I got an entry in a field called emailfrom in my table (MySQL db).

The data in that field is: Sams Bank [EMAIL PROTECTED]

I then do the following to retrieve the info, using a DB class

$recordset=$conn-Execute(SELECT * FROM wiml_history WHERE id =
$task_id);
$row=$recordset-GetArray();

$emailfrom=$row[0]['emailfrom'];

then I echo what I get out and I just get Sams Bank

It doesnt bring back the whole entry in that field,
however when I manually change the info in the field in the DB to:

Sams Bank [EMAIL PROTECTED], it retrieves it correctly.

Why does the   cause that not to be displayed? or is it retrieving it 
correctly but not showing it because of the   (which might be 
conflicting with HTML tags?

thanks in advance


-- 

Angelo Zanetti
Z Logic
www.zlogic.co.za
[c] +27 72 441 3355
[t] +27 21 469 1052
[f] +27 86 681 5885

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] RE: (SCL: 5) [PHP] query problem.

2006-01-24 Thread Richard Correia 
Remove those brackets  and .

Or

print htmlentities($email_address);

Thanks
Richard

On 1/24/06, Duffy, Scott E [EMAIL PROTECTED] wrote:

 Viewing in browser? If so view source.

 -Original Message-
 From: Angelo Zanetti [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 25, 2006 7:01 AM
 To: PHP List
 Subject: (SCL: 5) [PHP] query problem.

 Hi guys.

 I got an entry in a field called emailfrom in my table (MySQL db).

 The data in that field is: Sams Bank [EMAIL PROTECTED]

 I then do the following to retrieve the info, using a DB class

 $recordset=$conn-Execute(SELECT * FROM wiml_history WHERE id =
 $task_id);
 $row=$recordset-GetArray();

 $emailfrom=$row[0]['emailfrom'];

 then I echo what I get out and I just get Sams Bank

 It doesnt bring back the whole entry in that field,
 however when I manually change the info in the field in the DB to:

 Sams Bank [EMAIL PROTECTED], it retrieves it correctly.

 Why does the   cause that not to be displayed? or is it retrieving it
 correctly but not showing it because of the   (which might be
 conflicting with HTML tags?

 thanks in advance


 --