title: Copying a field and adding some text to it
body: <p>Hi I am trying to take the <code>gamename</code> field and put it into the <code>customTitle</code> field but add some text around it. So example is the game name is <strong>Balloon Pop</strong> in gamename I want <strong>Play Balloon Pop Now - FlameGame.net</strong> </p>
  
  <p>If you need more Information write comments to this question. Any help is greatly appreciated.</p>
  
  <p>--EDIT--</p>
  
  <p>And here is my code</p>
  
  <pre><code>&lt;?php
  if(isset($_POST['title'])) {
      $query = "SELECT * FROM games";
      $result = mysql_query($query) or die ("no query");
  
      mysql_query("UPDATE games SET gameKeywords=tags");
  
      $title = array();
      $id = array();
      while($row = mysql_fetch_assoc($result)){
          $title[] = $row['gamename'];
          $id[] = $row['gameid'];
      }
      foreach($title as $Stitle){
          foreach($id as $Sid){
      mysql_query("UPDATE games SET customTitle = 'Play ".$Stitle." Now - FlameGame.net' WHERE gameid LIKE '".$Sid."'");
  
  
          }
      }
  
  }
  ?&gt;
  </code></pre>
  
  <p>In the <code>db</code> it replaces all of the <code>customTitles</code> to the name of the first game.</p>
  
  <p>--EDIT--</p>
  
  <p>I figured out a mysql command that dose exactly what this program is supposed to do.
  Here it is:</p>
  
  <pre><code>UPDATE games SET customTitle = concat('Play ',gamename,' Now – FlameGame.net');
  </code></pre>