save the result data into mysql db

Hi,

I have this script to read the result data:

[CODE]
$note = “”;
echo “<h3>Data Dump</h3>”;
$data = file($tmp) or die(‘Could not read file!’);
//loop through array and print each line
foreach ($data as $line) {
$note = $note.$line.”<br>”;
}
[/CODE]

If I do this, it writes to the page with all the data:

[CODE]echo $note;[/CODE]

However, somehow when I stored in the database, the field NOTE has no data (BLANK). Other fields (hr, mr, interface, action) are fine. Also then datatype for NOTE field is set to TEXT.

[CODE]
mysql_select_db(“infs”, $MySQLconn);
mysql_query(“INSERT INTO inband_conversion_log (hr, mr, interface, action, [B]note[/B]) VALUES (‘$hrname’, ‘$clli’, ‘$interface’, ‘Remove Interface Confirm’, ‘[B]$note[/B]’)”);
mysql_close($MySQLconn);[/CODE]

Please help,
Thanks.

Also in #PHP _↴