<div>
There is nothing in the code that you have posted that will do that.
</div>


There is nothing in the code that you have posted that will do that.

<div>
You may want to parse the columns that may contain the CR/LF characters and if found, remove them and update the row with the new value.<br />
<br />
It should go something like this:<br />
<br />

<pre><code id="code-20-37865036-1">UPDATE table_name SET field_name=replace(replace(field_name, CHAR(13), ''), CHAR(10), '');</code></pre>
<br />
Try it on a test table first to see if you get the results you need.<br />
<br />
Also, for the future, look at what's producing the data that goes into the table. &nbsp;If needed, adjust that before it's inserted.
</div>


You may want to parse the columns that may contain the CR/LF characters and if found, remove them and update the row with the new value.

It should go something like this:



UPDATE table_name SET field_name=replace(replace(field_name, CHAR(13), ''), CHAR(10), '');


Try it on a test table first to see if you get the results you need.

Also, for the future, look at what's producing the data that goes into the table.  If needed, adjust that before it's inserted.

<div>
<div class="content wysiwyg-content">
Reading from a table into an array and generating a string from the array, I found that<br />
a CR/LF was occasionally introduced into the string. The string is used as a feed to a<br />
graphing program. <br />
<br />
How can this be fixed?
<pre><code id="code-8250694">       $array1=array();
       $acts=array();
       $acts['im'] =&quot;&quot;;
       
     $result=mysql_query($str, $link) or die(&quot;MySQL Error in reports: &quot;.mysql_error().&quot;  ** Query: &quot;.$str);

       while($row = mysql_fetch_array($result))
         {
           $array1[]=$row[1];
           $acts['im'] .= $row[1].&quot;,&quot; ;
         }
$acts['im'] =substr($acts['im'],0,-1);</code></pre>
</div>
</div>


Reading from a table into an array and generating a string from the array, I found that
a CR/LF was occasionally introduced into the string. The string is used as a feed to a
graphing program. 

How can this be fixed?

CR/LF introduced into array read?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.