[RESOLVED] mysql not returning full column

[john8675309]

I am having an issue with a select statement in a table

I have a column called from_addr it contains data like

"John Test" <[e-mail]>

when I run my sql code I get:

"John Test" but not the full result.

Here is my code:

$sql = "SELECT * from msgs where mail_id=\"$mail_id\" and content=\"S\"";
$result2 = $this->sql->query($escaped_item);
while ($row2 = mysql_fetch_array($result2)) {
    $from = $row2['from_addr'];
}
return $from;

the $sql->query function looks like this:

function query($query) {
    $result = mysql_query($query,$this->connect) or die (mysql_error());
    return $result;
}

Here is the table:

+-------------+------------------+------+-----+---------+-------+
| Field       | Type             | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| mail_id     | varchar(12)      | NO   | PRI |         |       |
| secret_id   | varchar(12)      | YES  |     |         |       |
| am_id       | varchar(20)      | NO   |     |         |       |
| time_num    | int(10) unsigned | NO   | MUL |         |       |
| time_iso    | char(16)         | NO   |     |         |       |
| sid         | int(10) unsigned | NO   | MUL |         |       |
| policy      | varchar(255)     | YES  |     |         |       |
| client_addr | varchar(255)     | YES  |     |         |       |
| size        | int(10) unsigned | NO   |     |         |       |
| content     | char(1)          | YES  |     | NULL    |       |
| quar_type   | char(1)          | YES  |     | NULL    |       |
| quar_loc    | varchar(255)     | YES  |     |         |       |
| dsn_sent    | char(1)          | YES  |     | NULL    |       |
| spam_level  | float            | YES  |     | NULL    |       |
| message_id  | varchar(255)     | YES  | MUL |         |       |
| from_addr   | varchar(255)     | YES  |     |         |       |
| subject     | varchar(255)     | YES  |     |         |       |
| host        | varchar(255)     | NO   |     |         |       |
+-------------+------------------+------+-----+---------+-------+

[sneakyimp]

Try viewing the source code in your result page. I would bet the part in the <angle brackets> is there but your browser is trying to interpret it as html. You should consider using the [man]htmlspecialchars[/man] function.

[john8675309]

You nailed it thank you! an str_replace fixed the issue!

[bradgrafelman]

Don't forget to mark this thread resolved.