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

From: Date: Tue, 24 Jan 2006 15:31:58 +0000
Subject: RE: (SCL: 5) [PHP] query problem.
Groups: php.general 
Request: Send a blank email to php-general+get-229174@lists.php.net to get a copy of this message
Viewing in browser? If so view source. -----Original Message----- From: Angelo Zanetti [mailto:angelo@zlogic.co.za] 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 <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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

« previous php.general (#229174) next »