query problem.
| From: | Angelo Zanetti | Date: | Wed, 25 Jan 2006 13:01:24 +0000 |
| Subject: | query problem. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-229168@lists.php.net to get a copy of this message | ||
Hi guys.
I got an entry in a field called emailfrom in my table (MySQL db).
The data in that field is: Sams Bank <sam@domain.com>
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 sam@domain.com, 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