query problem.

From: 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

« previous php.general (#229168) next »