Re: query problem.

From: Date: Tue, 24 Jan 2006 15:01:45 +0000
Subject: Re: query problem.
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-229172@lists.php.net to get a copy of this message
Angelo Zanetti wrote:
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 Have you looked into the source code?
Is there the Mail retrieved? Probably this can help -> http://de3.php.net/htmlspecialchars Greets Barry

« previous php.general (#229172) next »