PHP URL Generation
<p>I have a set of data being returned to a table using PHP and MySQL and I would like to put a link at the end of this data using elements from the row to build the link with some static elements.</p>

<p>i.e. $urlStart/name-installer-date-email-gno$urlEnd</p>

<pre><code>&lt;tr&gt;
                 &lt;th&gt;Installer Ref:&lt;/th&gt;
                 &lt;th&gt;Fitter&lt;/th&gt;
                 &lt;th&gt;Guarantee&lt;/th&gt;
                 &lt;th&gt;Equipment&lt;/th&gt;
                 &lt;th&gt;Installed&lt;/th&gt;
                 &lt;th&gt;Options&lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;
            &lt;?php
                $i=0;
                while ($i &lt; $num) {
                    /* $f1=mysql_result($result,$i,"installer"); */
                    $f2=mysql_result($result,$i,"fitter");
                    $f3=mysql_result($result,$i,"guarantee_no");
                    $f4=mysql_result($result,$i,"equipment");
                    $f5=mysql_result($result,$i,"certificate_no");
                    $f6=mysql_result($result,$i,"install_date");
            ?&gt;
            &lt;tbody&gt;         
                &lt;tr&gt;
                &lt;td&gt;&lt;?php echo $f5; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo $f2; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo $f3; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo $f4; ?&gt;&lt;/td&gt;
                &lt;!-- &lt;td&gt;&lt;?php echo $f5; ?&gt;&lt;/td&gt; --&gt;
                &lt;td&gt;&lt;?php echo $f6; ?&gt;&lt;/td&gt;
</code></pre>
