Re: query problem.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 2006-01-25 at 08:01, 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@xxxxxxxxxx>
> 
> 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@xxxxxxxxxx, 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


$emailfrom = htmlspecialchars($row[0]['emailfrom']);



-- 

s/:-[(/]/:-)/g


Brian        GnuPG -> KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu
======================================================================
gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC
Key Info: http://gfx-design.com/keys
Linux Registered User #339825 at http://counter.li.org

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux