title: get data from sql and show on specific location
body: <p>I m using the following query to get data from sql :</p>
  
  <pre><code>$query = mysql_query($sql);
  
  while($row = mysql_fetch_array($q))
    {
    $url = ''.$row['a'].'&amp;nbsp;'.$row['b'].'&amp;nbsp;'.$row['c'].'&amp;nbsp;'.$row['d'].'&lt;br&gt;';
    }
  </code></pre>
  
  <p>now i want to do replace {URL} (that is writen in html file ) with data from sql</p>
  
  <pre><code>$mtheme = str_replace("{URL}",$url,$mtheme);
  </code></pre>
  
  <p>echo $mtheme;</p>
  
  <p>the problem i that it shows only last row</p>