title: How do I show data from Mysql Database by line by line using a separator?
body: <p>I'm inserting my form data to Mysql Databasee in <strong>One Column</strong> called <code>notesUpdate</code>. Following is my php script which is inserting/Updating data to database but I use separator <code>___</code> because in this columns I'm inserting many data. I want to show this all single data line by line which is end with <code>___</code> . So that I'm using second Php script.</p>
  
  <p><strong>Insert/Update php script</strong></p>
  
  <pre><code>$contetn =  $_POST['contentText'];
  $cdid = $_POST['cdid'];
  $contetn .= "___"; 
  $query = mysql_query("UPDATE contact_details SET notesUpdate = CONCAT(notesUpdate, '$contetn') WHERE cdid = '$cdid' LIMIT 1");
  </code></pre>
  
  <p><strong>Show Php Script</strong></p>
  
  <pre><code>$query =  mysql_query("SELECT notesUpdate FROM contact_details WHERE cdid = '$id'");
  $row =  mysql_fetch_array($query);
  $notes = mysql_real_escape_string(htmlspecialchars(trim($row['notesUpdate'])));
  $ex =  explode("___", $notes);
  $ex[0];
  $ex[1];
  </code></pre>
  
  <p><strong>Show data should be look like this:</strong></p>
  
  <pre><code>Hello one data
  Hello two data
  Hello three data
  </code></pre>
  
  <p>But I've no idea how can I get this ? Can you suggest me or show my how can I get this ? Thanks.</p>
  
  <p><strong>Update:</strong> </p>
  
  <p>This is the form where all data is showing :</p>
  
  <pre><code>&lt;table width="500" border="0" cellspacing="0" cellpadding="0"&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;h2&gt;All Notes&lt;/h2&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type="text" name="cdid" value="&lt;?php echo $id; ?&gt;" id="cdid"/&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;textarea cols="65" rows="5" name="notesContent" style="padding:0; margin:0;"&gt; &lt;?php echo $ex[0]; ?&gt; &lt;/textarea&gt;  &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
     &lt;tr&gt;
      &lt;td&gt;&lt;input type="submit" value="Edit Notes" id="editNotes" class="submit" /&gt;&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>